how to sell items in PHP

berry05

how do i sell items in php? like text based game items..when a user has a item it goes to users_items table but i dont know how to make it so it can be sellable and add gold to the table users when a item is sold..

so far all i have is this which shows all the items the user has...i looked at the tutorial in the admins signature but it didnt help me when it comes to something like this though...

<?php session_start();

if(isset($_SESSION['otherusername'])){

$db=mysql_connect('localhost', 'root', '');

$res=mysql_select_db('textgame',$db) or die(mysql_error());


$otherusername = $_SESSION['otherusername']; //"SELECT item FROM users_items WHERE username='".$Username."'";

$res=mysql_query($otherusername)or die(mysql_error());


while($row = mysql_fetch_assoc($res)){


 echo $row['item'] . "<BR />";

  }
}else{

   echo "Sorry your not a member please join us!";
}

?>

kkobashi

This will get all items in the user_items table belonging to $otherusername.

$sql = "SELECT item FROM users_items WHERE username='" . $otherusername . "'";
$res = mysql_query($sql) or die(mysql_error());

To sell an item, you would have to INSERT the item into the user_items table. I'll leave that as an excercise for you to figure out. Basically look at the SQL INSERT command.

$sql = "INSERT INTO user_item (col1, col2, ... colN) VALUES (value1, value2,... valueN)";
$res = mysql_query($sql) or die(mysql_error());

Read about the sql INSERT command here:
SQL INSERT