Var outside of function?

[cmason22]

im a bit of a noobie, so sorry if this is insultingly simple...

i have something like:

$query= "SELECT......";
$results= mysql_db_query ($db , $query, $connection);

while ($Row = mysql_fetch_array ($results))
{
DO SOME STUFF
}
echo $Row[1] ;

seems that $Row[1] is empty because it is outside of the function. what can i do to pass, or enable the array beyond the scope of the function?

thanks!

[iceraider]

Do you want to get the first row?

[superwormy]

$query = "SELECT * FROM...";
$result = mysql_query ($query);
while ($array = mysql_fetch_array ($result)) {

// echo the first field in the table
echo $array[0];

// do some more stuff

}