somebody check pls

[narjis]

I am unable to execute mysql_num_rows properly in this program.

<?php
$link=mysql_connect("localhost","root","");
$db = mysql_select_db("myDB",$link);
$result = mysql_query("SELECT * FROM jobs WHERE jobType=abc"); 
$num = mysql_num_rows($result);
echo "Found $num records";
?>

error is mysql_num_rows() expects parameter 1 to be resource

[play_]

The query failed.

 

probably selecting from a wrong table or selecting wrong column.... i think.

 

You should look into PHP's PDO class http://php.net/manual/en/book.pdo.php

[trq]

You should always check your queries for success before using any data they might return.

 

if ($result = mysql_query("SELECT * FROM jobs WHERE jobType = 'abc'")) { 
    $num = mysql_num_rows($result);
    echo "Found $num records";
}

 

Note I also fixed your query which was missing quotes around the string 'abc'.