Declaring variables from a loop function

[ryclem]

Maybe I've just been look at this too long... but all I'm trying to do is to do a simple loop (with PHP and mysql) such as:

while($row = mysql_fetch_array($new)) {
$pagename = $row['pagename'];
$count = $row['count'];}

but I need to be able to declare the variables for a specific rows returned... i.e.

$page1_count = count where pagename = page1 (I need to do this for multiple pages)

I have my output table structure done, etc. it is just the individual variable value issue above... please help.

Thanks,
Ryan

[devinemke]

why not use a 2-dimensional array? i'll assume that pagename is a unique field in the table.

while ($row = mysql_fetch_array($new))
{ 
	$array[$row['pagename']] = $row;
}

now you have an array called $array with the pagename's as the keys and a sub-array of the row as the values. if you want to refer to the the count for pagename #123 then do:

echo $array['123']['count'];

[ryclem]

Perfect.... worked like a charm!

Thanks for your help...