Put MySQL queries into variables

[Darren]

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

[Ian B]

Use an array?

$day_plan[] = $row['day_plan'];

[Darren]

Cheers Ian,

I couldn't get my head round it.

Darren