msql error why?????

[baddawg]

this is the error :
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in index.php on line 147

this the code:
break;
case "10":

$result = mysql_query("SELECT pr_code, pr_totbedrooms, pr_name, pr_sellingprice, pr_descuk, (select prtypology_uk from prtypology where prtypology_code=$criteria_property) AS property_type FROM property WHERE (property.pr_type='0$criteria_property,' OR property.pr_type LIKE '%,0$criteria_property,%' OR property.pr_type LIKE '%$criteria_property,%') AND property.pr_publishonottk=-1");

$num = mysql_num_rows($result);

echo "<h2>Found objects: $num </h2>";

if ($num>10){

-----------------------------
why does it work on some server and some of them it don't please help

[DougBTX]

Try testing your SQL in phpMyAdmin.

MySQL questions go in the MySQL forum btw.

Douglas

[ClickHeRe]

$result = mysql_query("SELECT pr_code, pr_totbedrooms, pr_name, pr_sellingprice, pr_descuk, (select prtypology_uk from prtypology where prtypology_code=$criteria_property) AS property_type FROM property WHERE (property.pr_type='0$criteria_property,' OR property.pr_type LIKE '%,0$criteria_property,%' OR property.pr_type LIKE '%$criteria_property,%') AND property.pr_publishonottk=-1");

if ( mysql_errno() > 0 ) {
  echo mysql_error( );
  exit;
} 

[pitcher17]

why does it work on some server and some of them it don't please help

Older versions of mysql have different capabilities. Subqueries are one of those things.