• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Code to get table

Code to get table 12 years 6 months ago #19544

  • thiagocs
  • thiagocs's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
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>
$items = "|Please Select\n";
$db =&JFactory::getDBO();
$db->setQuery("SELECT DISTINCT(mail) FROM #__mail");
$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?)
Last Edit: 12 years 6 months ago by thiagocs.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!