[PHP] mysql_fetch problem

I have the following call: SELECT * FROM facility LEFT JOIN fuel USING(facilityID) LEFT JOIN fuelType ON fuel.TypeID=fuelType.ID WHERE facility.facilityID=$facilityID The data is returned properly using mysql_fetch_row(), but mysql_fetch_assoc() and mysql_fetch_object() set the ID of the facili

[PHP] mysql_fetch..........

Greetings ! I have a table in mysql: id item 1 Apple 2 Orange 3 Banana I displayed all the items in HTML with PHP while ($row=mysql_fetch_array($query)) { $item=$row["item"]; echo " "; }; Now if I want to capture Banana or any other particular item from the displayed HT