Multiple array returns?

[Anon]

I am using the mysql_fetch_Array function to store fields out of a database.
I was wondering if you could use, for example, $myrow["Artist"] twice, once in a query string, and another time as plain text. Ex

<a href=music.php?artist=<php echo $myrow["Artist"]; ?>"><php echo $myrow ["Artist"];?></a>

Would this work, or screw everything up?
Is there any other way I can do this?

[Anon]

That should work fine. You are storing the resulting row in the array variable $myrow then referancing the element "Artist" of that array. You can referance that element as many times as you want, until you get back around in your loop and re-populate $myrow with the next row from your select.

[Anon]

Talking to yourself? :-)