5 rows return, how to store each row to different variable

sunnyside

I used query to retrieve one field of data from table and will return more than one record(for example 5). How can I define these 5 different values into 5 variables.

something like:

$fd_dep_1 = $row[0];

$fd_dep_2 = $row[1];

$fd_dep_3 = $row[2];

devinemke

assuming mySQL

$result = mysql_query('SELECT field FROM table');
$i = 1;
while ($row = mysql_fetch_row($result))
{
	$varname = 'fd_dep_' . $i;
	$$varname = $row[0];
	$i++;
}

sunnyside

Originally posted by devinemke
assuming mySQL

$result = mysql_query('SELECT field FROM table');
$i = 1;
while ($row = mysql_fetch_row($result))
{
	$varname = 'fd_dep_' . $i;
	$$varname = $row[0];
	$i++;
}

[/B]

Thank you so much. That's what I want.:p :p

I really appreciate your BIG help!

The_Terminator2

An alternative, and slightly more structurally sound approach would be to use the list(...) function, for example from the php dot net website

...
<?php

$result = mysql_query("SELECT id, name, salary FROM employees", $conn);
while (list($id, $name, $salary) = mysql_fetch_row($result)) {
   echo " <tr>\n" .
         "  <td><a href=\"info.php?id=$id\">$name</a></td>\n" .
         "  <td>$salary</td>\n" .
         " </tr>\n";
}

?>
...

http://us2.php.net/manual/en/function.list.php