|
|
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 </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 </td></tr>",$row[0]["venue"]);
>Should be:
> valign='top'>%s </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
[Back to original message]
|