you should be able to just change the mysql_fetch_row to a mysql_fetch_array and then use the names rather than the numbers in your print (modified below, not tested :)
// <? // $user = "root"; // $pw = ""; // $db = "pete"; // // $mysql_access = mysql_connect("localhost", $user, $pw); // mysql_select_db($db, $mysql_access); // // $result = mysql_query("select test2,test1,id from test", // $mysql_access); // while($row = mysql_fetch_array($result)) // { // print($row["field1"] . " - " . $row["field2"] . " - " . $row["field3"] . "<br>"); // } // ?> /beau -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]