You are overwriting the first row.
$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");
if(mysql_num_rows())
while ($row = mysql_fetch_array($result)
{
echo "$row[club_id]";
echo "$row[id]";
echo "$row[ac_year]";
echo "$row[ac_type]";
}
else .....blablabla....
...Or...
$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)
do {
echo "$row[club_id]";
echo "$row[id]";
echo "$row[ac_year]";
echo "$row[ac_type]";
} while($row = mysql_fetch_array($result));
else .....blablabla....
-----Original Message-----
From: Seany [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 2:09 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] losing first row of an array
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]
--
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]
