Sql query executing perfectly in phpmyadmin but giving warning while running on page

Question

i don't know whats wrong with this sql query.

SELECT * FROM main WHERE key LIKE '%$word%'

its giving results in phpMyAdmin but giving warning while executing it in a php page.

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

Answer 1

This warning means you are not passing a valid resource to mysql_fetch_array().

Make sure you check the return value of mysql_query() and just to be sure try dumping your query just before you call mysql_query().

$res = mysql_query($query);
if(! $res) {
 die('Query exec failed'.mysql_error());
}