Posted by Hendri Kurniawan on 03/06/07 00:56

gcox freeuk.com wrote:
> Hello,
>
> I am using php and MySQL and have following as part of the code
>
> while ($row[] = mysql_fetch_array($result)) {
> printf("<td valign='top'><strong>Venue</strong></td><td _
> valign='top'>%s &nbsp;</td></tr>",$row[0]["venue"]);
>
> etc etc
>
> but with more than one hit it does not work, I just get a repeat of
> the first set of data but not using the table formatting.
>
> Ideas please?
>
> Cheers
>
> Geoff

This:
while ($row[] = mysql_fetch_array($result)) {
should be
while($row = mysql_fetch_array($result)) {

This:
valign='top'>%s &nbsp;</td></tr>",$row[0]["venue"]);
Should be:
valign='top'>%s &nbsp;</td></tr>",$row["venue"]);


Hendri

• Next in forum: Re: List Fails on some computers - www missing in url
• Prev in forum: php and MySQL error
• Thread view: Re: php and MySQL error

[Reply to this message]