is there a personal details table in your database??
if so, you may get all those value like userID,name from this table by a key
$id
on the other hand, try to not use the session to get the uid

"Jennifer Downey" <[EMAIL PROTECTED]> glsD
:[EMAIL PROTECTED]
> Hi all,
>
>  I guess I should have gone ahead and put the whole code in because I
didn't
> get accomplished what I set out to do in the last if else question.
>
> I found a slight bug and am wondering if someone could help.
>
> If another user logs in and buys the same item as I do then my item is
> updated instead of adding the second user to the db and viseversa if they
> buy a different item.
>
> I have tried elseif with the uid but I am getting no where fast does
anyone
> have any ideas?
>
>
>
> $id = $HTTP_GET_VARS["id"];
>
>
> $check_points = "SELECT points FROM {$config["prefix"]}_users WHERE
> uid={$session["uid"]}";
> $ret=mysql_query($check_points);
>
> while(list($points)=mysql_fetch_row($ret))
> {
> $cost=$HTTP_SESSION_VARS['price'];  // Gets the price of the item. replace
> with $_SESSION['price'] if PHP version >= 4.1.0
>             //echo $cost;
>   if($points < $cost) {
>     echo "You don't have enough StarrCredits to purchase this item!"; //
If
> there arent enough points to buy
>   }
> else
> {
>     // If there are enough points to buy then subtract the price from the
> users points
>     $query = "UPDATE {$config["prefix"]}_users SET points = points - $cost
> where uid={$session["uid"]}";
>     mysql_query($query);
>   // Updates the quantity
> $query ="UPDATE {$config["prefix"]}_items SET quantity = quantity - 1
where
> id = '$id'";
> $ret=mysql_query($query);
>
> // 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;
>
> // We are selecting everything from item where the id match the clicked
item
> for insert into users items
> $query = "SELECT * FROM {$config["prefix"]}_items where id = '$id'";
> $result = mysql_query($query);
> $row = mysql_fetch_array($result);
> $name = $row[name];
> $pid = $row[image];
> $itemid = $row[id];
>
> // We are checking to see if the item exists in the user items
> $query = "SELECT * FROM {$config["prefix"]}_my_items where id = '$id'";
> $result = mysql_query($query);
> $row = mysql_fetch_array($result);
> $iname = $row[name];
> $ipid = $row[image];
> $iitemid = $row[id];
>     if (mysql_num_rows($result) == 0)
> //This is where I think the problem is but I can't seem to figure  it out.
>     // If the item doesn't then insert it into the users items
> {
> $query = "INSERT INTO {$config["prefix"]}_my_items (uid, id, name, image)
> VALUES ('$user', '$itemid', '$name','$pid')";
> $ret = mysql_query($query)
>                  or die("Unable to insert into the database");
>
>     }else{
> // If it does exist the just update the quantity
> $query_update ="UPDATE {$config["prefix"]}_my_items SET quantity =
quantity
> + 1 WHERE id = '$id'";
> $result=mysql_query($query_update);
>
> }
>
>  }
> }
>
> Any help is appreciated
> TIA
> 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

Reply via email to