Maybe change mysql_fetch_array($ret) to mysql_fetch_row($ret)? Not sure but I've used that before to do what appears to be similar while loops.. Wouldn't the data still get retrieved in array form with that? If I'm wrong, feel free to publicly ridicule me..
Later, Bob Weaver "Jennifer Downey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi everyone, > > I originally posted this in general by mistake. > > I have a question about this code. The way it sits now it always shows the > last record in the database table. > In other words if the user has 6 items, like: > item id 1 > item id 2 > item id 5 > item id 6 > item id 7 > item id 8 > > it will only show the last record item id 8. > > I believe it has something to do with the first while statement's closing > curly bracket placement > but I can't seem to get it in the right place. > > Can someone spot the mistake and show me how to fix it. > see also comments in code. > > > > $id = $HTTP_GET_VARS["id"]; > > > $query = "SELECT id, name, image, quantity, type FROM > {$config["prefix"]}_my_items WHERE uid={$session["uid"]} ORDER BY id"; > $ret = mysql_query($query); > while($row = mysql_fetch_array($ret)) > { > $iid = $row['id']; > $image = $row['image']; > $name = $row['name']; > $quantity = $row['quantity']; > $type = $row['type']; > > > if($iid == $id) > { > $display_block ="<CENTER><img src=$image border=0><br><font size = > 2>$name<BR>$quantity<BR>$type</font></CENTER>"; > echo "$display_block<BR><BR>"; > if($type == "food") > //if book or weapon is present then set an option and include in the form > later > {$thisoption="<OPTION VALUE=\"feed\">Feed my pet\n</OPTION>"; > }else{ > //if any other type is present then set a blank > $thisoption="";} > } > } > > > > //check if form has been submitted > if($submit){ > > if($sort == 'shop') > { > echo "This item has been taken care of<BR>"; > > // We are selecting user id to insert into the users items. > $db="SELECT uid FROM {$config["prefix"]}_users WHERE > uid={$session["uid"]}"; > $ret = mysql_query($db); > while(list($db)=mysql_fetch_row($ret)) > { $user = $db; > echo "Your user ID is $user<BR>"; > } > > > echo "You have $quantity of this item and it's id is $iid<BR>"; > > > } > // it seems like the first while statement's closing curly bracket should go > //here but if I put it here I get a parse error. > }else{ > //if the form has not been submitted run the following > > > ?> > <FORM ACTION="<?echo"$PHP_SELF";?>" METHOD="post"> > <SELECT NAME="sort" SIZE=1 > > <?echo "$thisoption";?> > <OPTION VALUE="shop">Put in my shop</OPTION> > <OPTION VALUE="locker">Put into my Footlocker</OPTION> > <OPTION VALUE="discard">Discard this item</OPTION> > <OPTION VALUE="donate">Donate this item</OPTION> > </SELECT> > <INPUT TYPE="submit" VALUE="Submit" NAME="submit" > > </FORM> > <? > } > //if I put the first while statement's closing curly bracket here it works > except it prints multiple dropdown lists on the page and only prints the > first item id 1. > > I have tried the bracket in numerous places but I can't find the right spot. > > Thanks in advance > Jennifer > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
