hi. newbie needs some debugging help. i can connect to my mysql db with no problem but it doesn't like this section of code.
mysql_select_db("test");
$query = "select * from test where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
the last line of code generates this error message, "supplied argument is not a valid mysql result resource."
i don't know what it means. please advise. thanks.
peter
mysql_select_db("test");
$query = "select * from test where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
the last line of code generates this error message, "supplied argument is not a valid mysql result resource."
i don't know what it means. please advise. thanks.
peter