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: [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]
