you need to use the *_fetch_array() functions i.e. if you are using MySQL
$SQL = "something"; // build SQL query $result = mysql_query($SQL); // execute query, save all results in $result $firstResult = mysql_fetch_array($result); // create an array containing each returned record // subsequent calls to mysql_fetch_array($result) will get each record HTH Beau PS please excuse email butchering my single-line comments :) // -----Original Message----- // From: planomax [mailto:[EMAIL PROTECTED]] // Sent: Monday, 14 January 2002 10:13 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Can't use field names in print // // // To output each row, this works: // // print("$row[0] - $row[1] - $row[2]<br>"); // // But using the table's field names, I don't see anything: // // $ID=$row["ID"]; // $test1=$row["test1"]; // $test2=$row["test2"]; // print ("$ID - $test1 - $test2<br>"); // // I'm used to using Cold Fusion and want to learn PHP. Any // help would be // appreciated. Thanks. // Pete // // // // -- // 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] // -- 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]