Posted by Jerry Stuckle on 09/11/06 00:48

Steve wrote:
>
>> I then use mysql_result() to get the category name from the first row
>> (since it will be the same in all rows). The problem I'm having is
>> that when I use mysql_result(), the data from the last row in the
>> result set is not displayed, even though the HTML for that row is
>> written out, and the "No parts found for this category" message is
>> written to the page (see below).
>
>
> I went back and looked again, and discovered that it is actually the
> first row in the returned data that is not displayed, not the last row.
> So it looks like what's happening is that mysql_result() is removing the
> data from the first row (the row I'm reading the get the category name),
> but it looks like the row is actually there when mysql_fetch_array() is
> extracting the data, hence the empty row displayed in the table.
>
> Steve

Ah, now I see this update :-)

See my update above. No, you can't mix mysql_result() and
mysql_fetch_array() successfully.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]