Hi
Well, i have this code to get the users in my DB. My programmer is on vacation and would like to know if anyone can help me get the result table X in other registration program.
Code:
//<code>
$items = "|Please Select\n";
$db =&JFactory::getDBO();
$db->setQuery("SELECT DISTINCT(users) FROM #__users");
$result = $db->loadResultArray();
for($i=0;$i< count($result);$i++)
{
$items .= $result[$i].'|'.$result[$i];
if($i<count($result)-1){
$items .= "\n";
}
}
//echo $items;
return $items;
//</code>
I need to get data from a table that has the record of the Company's subsidiaries.
So I just wanted an example of how the code would be, example:
("SELECT DISTINCT (TableX?)
krileon
