You are here: Re: Using mysql_result() Deletes Row From Result « PHP Programming Language « IT news, forums, messages
Re: Using mysql_result() Deletes Row From Result

Posted by Steve on 09/10/06 21:25

> 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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация