PHP/MySQL Developer

Web & Mobile Development Web Development Posted 2 years ago

Hourly Job

Hours to be determined
Less than 1 week

Details

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?

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Applicants: 62

Hired: 1


About the Client

(4.85) 80 reviews

United States
Sugar Land 03:40 AM

160 Jobs Posted
71% Hire Rate, 1 Open Job

$5,522 Total Spent
136 Hires, 5 Active

$3.69/hr Avg Hourly Rate Paid
1,151 Hour

Member Since Dec 9, 2011