PHP Forums Archive

Multiple PHP / MySql search and results in table with pagination

Tags: mysql, search, multiple search

theduke posted on 2008-12-29 02:21:37 #

Hi guys,

I'm a NOOB in php or mysql .. :( I want to be able to do multiple searches from a form and get the results in a table, paged . I really dont know how to do this.. I spent days on google and nothing :( or I'm too dumb to understand it.. PLEASE HELP ME :)
Here is my code including form and php code with pagination etc.. (I guess that is something with the sql query .. but I think I tried anything . If I select only one input works great, if I select more than one input it returns almost all database :( )

some removed code block...

Please modify the script so I can be able to post multiple inputs and get only the results selected .

Thank you in advance !

Comments / discussions

Olaf posted on 2008-12-29 06:33:47 #

Hi,

sorry no one can analyze your whole code for free ;)

if you have multiple search results it might be useful to store them inside an array or just pass the limit to the database query.

This snippet might help too:
http://www.finalwebsites.com/snippets.php?id=37

but don't accept to much this is not job for a php newbie...