Posted by gcox on 03/06/07 07:02

On Tue, 06 Mar 2007 11:56:26 +1100, Hendri Kurniawan
<ask-me@email.com> wrote:

>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,

Thanks for the above - that almost works! I do now get the 2 hits but
the second one does not have the <table format?!

Cheers

Geoff
>
>
>Hendri

• Next in forum: Re: php and MySQL error
• Prev in forum: Re: message sent with mail() caught as spam
• Thread view: Re: php and MySQL error

[Reply to this message]