Loops help.

Anon

I am currently using this code to gather information for my database duh

$result = mysql_query("SELECT * FROM user ORDER BY name DESC");
if ($myrow = mysql_fetch_array($result)) {

do {
    printf("<td>%s</td>\n", $myrow["nameofitem"]);
      } while ($myrow = mysql_fetch_array($result));

} else {
    echo "<center>Sorry, no users are avaliable!</center>";	
}

Now my question is how would I go about getting the information it calls into sperate variables? like

$myrow[1]
$myrow[2]

how would I get this to work??

Anon

mysql_fetch_array() returns an array.

So if you do:

$myrow = mysql_fetch_array($result);
// now you can use $myrow[0] and $myrow[1]

Diego

Anon

Err I forgot add add one thing. To call the information I have to use something like this $myrow[username] ... now it loops that but to waht I have no clue and to how I can get a seperate variable for each of them confuses me..

Anon

Do you mean this?

$myrow = array();
while ($myrow[] = mysql_fetch_array($result));

Diego