No public ridicule, although it doesn't work. >From what I understand $query = "SELECT id, name, image, quantity, type FROM is an array so if I were to use mysql_fetch_row($ret) it is only returning 1 row. where as mysql_fetch_array($ret) is returning the whole array.
However I could be wrong to. But that is the way I understand it to be. ;) But thanks for trying. Jennifer <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > > > > > > --- 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