Page 1 of 1

PHP - MYSQL creating an Advanced query from Form output

Posted: Mon Feb 25, 2008 3:31 pm
by afletcher
Hello all, I have just started using PHP to communicate with my Mysql server and am struggling to figure out how I can produce a section of code to contruct a single $query variable out of a "form post"
Example:
Form has 7 fields, FName,LName,Town,Postcode......etc
User chooses to search entering only one field (FName)
Submits
I now need a php script to check all feilds for existence of strings and then create a Myqsl Query with the fields pnly that have string....

Hope this makes sense...

Look forward to any help and guidance...

Fletch :banghead: