• 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: VALUE FROM HIDDEN TO MYSQL QUERY

VALUE FROM HIDDEN TO MYSQL QUERY 8 years 6 months ago #35987

  • chris13
  • chris13's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
hi, i set a value in page 1 (UID) and want to reference it later on to do a mysql query how is this possible??

here is what i have tried (unsuccessfully)
B)
//<code>
$items = array();
$db = JFactory::getDbo();
$uid = $_GET;
$items[] = "Please Select|Please Select[c]";
$items[] = "0|
";
$db->setQuery("SELECT * FROM malt.mlt_formation_tmp_capital WHERE uid='$uid'");
$results = $db->loadObjectList();
foreach ($results as $result) {
$value = $result->shareType;
$label = $result->shareType;
$items[] = $value.'|'.$label;
}
$items = implode("\n", $items);
return $items;
//</code>
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!