double check query statement??

$query = "SELECT mpn_job.ID, job, assigned_to, status_date, category"; $query .= "FROM mpn_job, mpn_job_category WHERE CID =

                           mpn_job_category.ID";

$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? Thanks.