im new to joomla and im trying to build a component which is an addon for viruemart to allow users to access invoice PDF's in their user area. To do this i need to write a select query which retreives this information from the database for me.
I have been messing around with it and came up with the following, but it doesnt seem to do anything:
$id =JFactory::getUser()->id;
$db =& JFactory::getDBO();
$sql = "SELECT * FROM jos_vm_orders";
$db->setQuery($sql);
$options = $db->loadObjectList();
return $options;
Am i missing something?
You can check this doc for database queries - http://docs.joomla.org/API16:JDatabaseQuery
Cross check your table prefix.Or try this-
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*');
$query->from('#__vm_orders');
$query->where('id = 1'); //put your condition here
$db->setQuery($query);
//echo $db->getQuery();exit;//SQL query string
//check if error
if ($db->getErrorNum()) {
echo $db->getErrorMsg();
exit;
}
return $db->loadObjectList();