Not actually sure what you want, but this might do it :) $j = 0; While($Row = mysql_fetch_array($Result)) { $email[$j] = $Row['email']; ... ... $j++; } -----Original Message----- From: Ross [mailto:ross@xxxxxxxxxxxxx] Sent: Monday, October 02, 2006 7:09 PM To: php-general@xxxxxxxxxxxxx Subject: a function for retuned vatiable What I need is a quick way to assign variable names to the same value of the row name. example.. $query= "SELECT * from $table_name WHERE sname=='hulford'"; $result = mysql_query($query) or die('Error, query failed'); while ($row=mysql_fetch_array($result)) { $email = $row['email']; $name=$row['name']; $address = $row['address']; //this goes on for 30 fields is there a way to automate this? } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php