Forums

Need help in searching data from mySQL & return the same pag

jmarian1 20 Nov, 2009
HI, I am trying to create a form that search the data from a specific table using this extension and somehow it always say enter search parameter or cannot connect to database. Myabe if you can direct me to the instruction on how to use the table that I created and how to get the query. My query doesn't work using
SELECT fieldname FROM tablename WHERE fieldname LIKE '%" . $idnameinform .  "%' OR fieldname2 LIKE '%" . $idnameinform ."%'"


Please help. I need to make this work in order for me to move on and I am trying to do this for almost two days now and can't get an answer. Is there any instructions on how to use the chronoforms properly using the database?

Thank you so much for your help in advance. I hope to hear from you as soon as possible as I am getting depressed with the outcome. Thanks.
GreyHead 20 Nov, 2009
Hi jmarian1,

You don't say how you are using this code or what other code you have around it. The query looks OK as a MySQL/PHP snippet but the variables need to be defined, the database object loaded and the query executed.

If you post the whole of your code fragment then we can help; meanwhile there are hundreds of examples of Joomla database queries in the forums here. Try searching on getDBO

Bob
This topic is locked and no more replies can be posted.