Posted by Darren on 11/24/05 13:20

The following query returns 7 codes, how do I put each of them into a
separate variable?

$result = mysql_query("SELECT day_plan FROM calorie_plan WHERE calories
= '$calories'");
if (!$result) {
die('Invalid query: ' . mysql_error());
}
while ($row = mysql_fetch_array ($result))
{
$day_plan = $row['day_plan'];
}

I'm sure I've done this before but I can't remeber how or where.

Many thanks

Darren

[Back to original message]