losing first row of an array
| From: | Seany | Date: | Fri, 02 Nov 2001 19:09:19 +0000 |
| Subject: | losing first row of an array | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13956@lists.php.net to get a copy of this message | ||
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