$query = "SELECT mpn_job.ID, job, assigned_to, status_date, category";
  $query .= "FROM mpn_job, mpn_job_category WHERE CID =
  $query .= "AND category = '$category'";
  $result = mysql_query($query);
  $row = mysql_fetch_row($result);
  foreach ($row as $data) {
         echo "$data[0]";

I tried the SELECT statement from mysql command line (less $category, I 
used an actual category name) and it works there.  I try it out in php, 
and I get nothing.  (I echoed $category before this and it works 
correctly)  Do you guys see anything in there that may need correcting? 

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to