A simple query

[Vinnepin]

Hey guys,

i got a really strange problem :

i made a search box and a mysql_query to search for that search string , but it goes wrong..

here i show u , when i use this query :

$sql = mysql_query("SELECT * FROM file_specs WHERE description or name Like '%$search%' LIMIT $limitvalue, $limit");

Then the query only searches in the column name and not the description column.

When i try this :

$sql = mysql_query("SELECT * FROM file_specs WHERE name or description Like '%$search%' LIMIT $limitvalue, $limit");

Then the query only searches in the column description and not the name column.

So the problem is that the OR function in the query does not work how it should work 😛

Do u guys know what im doing wrong here??

[ahundiak]

... where description Like '%$search%' or name Like '%$search%' limit ...