My apologies for putting this in the wrong list. Jennifer
"Jennifer Downey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi everyone, > > I have a question about this code. The way it sits now it always shows the > last record in the 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 bracker > 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 pars 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 > great except it prints multiple dropdown lists on the page. > > I have tried the bracket in numerous places but I can't find the right spot. > > > > > > --- > 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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php