Re: losing first row of an array
| From: | Steve Cayford | Date: | Fri, 02 Nov 2001 20:13:21 +0000 |
| Subject: | Re: losing first row of an array | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13959@lists.php.net to get a copy of this message | ||
On Friday, November 2, 2001, at 01:09 PM, Seany wrote:
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);Here you've fetched the first row...
if ($row = mysql_fetch_array($result)) {...and here you've overwritten it with the second row. You probably just want: 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.... 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net