$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.
--
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]