mysql_num_rows problem

[pouncer]

$s1 = mysql_query("SELECT * FROM collection WHERE collection_name LIKE %old% OR collection_name LIKE %houses%");
echo mysql_num_rows($s1);

 

error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

but when i change my query to:

$s1 = mysql_query("SELECT * FROM collection");

 

then it works fine. can someone please tell me whats wrong?

[esukf]

missing single quotes around strings

$s1 = mysql_query("SELECT * FROM collection WHERE collection_name LIKE '%old%' OR collection_name LIKE '%houses%'");

[kenrbnsn]

You need to put the strings in the LIKEs in single quotes:

<?php
$s1 = mysql_query("SELECT * FROM collection WHERE collection_name LIKE '%old%' OR collection_name LIKE '%houses%'");
echo mysql_num_rows($s1);
?>

 

Ken

[MadTechie]

TRY

$s1 = mysql_query("SELECT * FROM collection WHERE collection_name LIKE '%old%' OR collection_name LIKE '%houses%'");
echo mysql_num_rows($s1);

[MadTechie]

LOL

 

3 hits

[pouncer]

thanks alot guys, that pc_nerd guy mislead me, by telling me it was correct.

 

Thanks guys!!!