PHP/MySQL Developer

PHP/MySQL Developer

Closed - This job posting has been filled.

Job Description

I need some help on an error I'm receiving on numerous pages on my site. The error is below: [17-Jun-2013 16:22:12 America/Denver] PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/estage/public_html/admin/client-job-details.php on line 466

The code is:

<?
$kount_i = 0;
$result_pt = mysql_query("SELECT ID, position_name, position_type_code, Is_active FROM position_types ORDER BY position_name ");
while($row_pt = mysql_fetch_array($result_pt))
{ $kount_i++;
if ($kount_i==1){echo "<td nowrap>";}{echo "</td><td nowrap>";}
echo "<input type='checkbox' name='position_name_".$row_pt['ID']."' value='".$row_pt['position_name']."'";
$position_type_id=$row_pt['ID'];
$result_pta = mysql_query("SELECT position_name,position_type_id FROM client_position_types WHERE client_id=$cid AND position_type_id=$position_type_id ");
if (mysql_num_rows($result_pta) != 0 ){ echo " checked"; }
echo ">".$row_pt['position_name']." ";
if ($kount_i==3){echo "</td></tr><tr>";$kount_i=0;}
}
?>


PLEASE LET ME KNOW HOW MUCH IT WILL COST TO FIX AND HOW LONG?

Other open jobs by this client