help the simple query will not work

[billspeg]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\orderform\results.php on line 24

mysql_select_db("bookorama");
$query = "select * from bookorama where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

help please the variable are correct from the form as well

[nnichols]

Run your query like this -

$sql = "your query";
$result = mysql_query($sql)
  or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

then, when the query fails you should get a useful error message.

Hope this helps 😉

[tomhath]

Missing single quotes around $searchtype?