having this code running PHP4.0b2 $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id, clubac.ac_year, clubac.ac_type, club.id FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id = club.id");
$row = mysql_fetch_array($result); if ($row = mysql_fetch_array($result)) { do { echo "$row[club_id]"; echo "$row[id]"; echo "$row[ac_year]"; echo "$row[ac_type]"; } while($row = mysql_fetch_array($result)); } else .....blablabla.... is there a fundamental miss on my part why the is printing the first or not even recognising it if call direct in mysql with the above query it's fine with the results even if there is 1 row duh??? Seany -- 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]