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

Reply via email to