[Resolved] Multiple search problems

davieboy

I am trying to do a muliple search of a database.

total of 5 fields

i am trying

mysql_select_db($db_name,$dblink)
or die(mysql_error());
$sql = mysql_query("SELECT * FROM clients WHERE town = '%location%' AND style = '%ptype%' ",$dblink)
or die(mysql_error());

but it just returns a blank page when i enter the search term.
a term i know that should pull back resuults

i am making sure i can get 2 variables to work before doing the 5

any ideas why

Weedpacket

I think you mean "LIKE" not "=".

TheDefender

Also:

$sql = mysql_query("SELECT * FROM clients WHERE town LIKE '%[B]$[/B]location%' AND style LIKE '%[B]$[/B]ptype%' ",$dblink) or die(mysql_error());

Don't forget your $ signs. The way you currently have it without the dollar signs, the query is literally looking for a row where town is the word "location" and style is the word "ptype".

davieboy

have put the like and $ in and its seams to be going

i am lookging at : http://www.phpbuilder.com/board/showthread.php?s=&threadid=10276635&highlight=php+SEARCH

as it seams to be the idea am looking for

cheers for help.
:p

davieboy

next issue

the breaking search up into pages

have looked and edited a turorial on it but just get errors etc.

is there any breakdown 4 thick as mince idiots like me?

TheDefender

np davieboy. Don't forget to mark this thread resolved. Have a nice day ;-) and you may want to start this "breaking up search" topic as a new thred.

When you say: "breaking up search" do you mean you want to show results 1-10 on one page, and 11-20 on the next, etc... If so, you may want to search this forum on "pagination". This topic has been covered extensively with a ton of different results and ways of doing it.

davieboy

cheers

was nto 100% sure on what to call it