Do I always have to reassign variables returned?

[nightdesigns]

This is my first post here, You will probably be seeing a lot more of me soon.

Right now when I want to display results from my SQL db I use code like this:

$id=mysql_result($result,$i,"id");
$identifier=mysql_result($result,$i,"identifier");
$Name=mysql_result($result,$i,"Name");

There is an while statment to cycle each returned record.

Currently I have to reassign all the variables. Is there a way that I can refrence the names of the variables from the DB directly when displaying results?

Thanks!

[NogDog]

Start by looking at the example on the reference page for the mysql_fetch_assoc() function.