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]

Reply via email to