|
Welcome,
Guest
|
|
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: How can I query submissions?
How can I query submissions? 11 years 10 months ago #23804
|
Hi guys, I have the following attached table. I use this table on an Ipad for our reception area, its to log-in visitors.
I need to be able to query mysql a list of firstnames listed under "Fieldvalue" where Signout listed under "FieldName" is empty. So I tried the following query, but unfortunately I get an empty query.
SELECT fieldvalue FROM `ob14t_rsform_submission_values` WHERE FieldName = 'firstname' AND fieldname = 'Signout' IS NULL
And
$db = &JFactory::getDBO();
$db->setQuery("SELECT `FieldValue`, `FieldName` FROM #__rsform_submission_values WHERE `FieldName` = 'firstname' OR `FieldName` = 'Signout'"); $results = $db->loadObjectList(); Basically the result I want is to see who has logged into our sign-in form, this should be easily achieved since the "signout" field is empty during their signin process. Whoever has not signed out should be listed in a dropdown with the option to signout by clicking on "submit". Upon clicking on submit, the current time/date is inserted to the "Signout" field. Thank you so much for looking into this form me, I havent been able to solve this. I have an open ticket at Experts-Exchange ( www.experts-exchange.com/Database/MySQL/Q_28101807.html ) but those SQL guru's we'rent able to solve it either. I'm hopeful you guys can. Thank you.  |
|
|
|
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!
