• 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: php script for sql search!!!???

php script for sql search!!!??? 10 years 1 month ago #30670

  • sapoco
  • sapoco's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
Hello,
I have a question, I 'v search so much but I couldn't find the proper answer. I have a form which there is a text in it that a user should insert a unique code in the mentioned text and after inserting and sending a code by the user, a unique message displays for him. I put the code below in a call script part after the processing but it doesn't work.

//<code>
$my = & JFactory::getUser();
$db = JFactory::getDBO();
$db->setQuery("SELECT `matn` FROM `testm` WHERE `laser`='{codeLaser:value}'");
$thankYouMessage = $db->loadResult();
//</code>

But if I put a fixed code which exists in the database, instead of laser code field, it displays the text of the code.

//<code>
$my = & JFactory::getUser();
$db = JFactory::getDBO();
$db->setQuery("SELECT `matn` FROM `testm` WHERE `laser`='69237161'");
$thankYouMessage = $db->loadResult();
//</code>

please HELP
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!