easy insert question, im missing something here

jcrensha627

below i have a written code that takes info from a table on a db and does a calculation. I want be able to add information to another table named trades, i thought this could be done using my $insert query below. I want to insert in the table trades the following: an auto inc ID,JAME,what was posted to the quantity box and finally the total cost of the transaction. also im tryin to add the logged in users name to a colum in trades. my errors are below.

so if user jimbo bought 10 JAME at $50/JAME =$500 i want the table to show this in the db

id | JAME | 10 | $500.00 | Jimbo

<html>
<body>
Go Back to<a href="index.php">Your Portfolio</a>
<br>
<br>
Are you sure you want to buy shares in JAME? (Total Below)
<br>
<br>
<?php
ob_start();
include("config.php"); 
$username = $_COOKIE['loggedin'];
if (!isset($_COOKIE['loggedin'])) die("You are not logged in, <a href=../login.html>click here</a> to login.");

// connect to the mysql server 
$link = mysql_connect($server, $db_user, $db_pass) 
or die ("Could not connect to mysql because ".mysql_error()); 
// select the database
mysql_select_db($database) 
or die ("Could not select database because ".mysql_error()); 
$get_my_basket = mysql_query("SELECT `symbol`, `price` FROM `Athletes` WHERE `symbol`='".JAME."'");
  $total_cost = 0;
  $JAME = 0;
  $quantity = $_POST['quantity'];

while($my_basket = mysql_fetch_array($get_my_basket))
{
  if($my_basket['symbol']=='JAME') $JAME++;
  $total_cost += $my_basket['price'] * $quantity; 
}
echo 'You have selected: ';
if($JAME > 0) 
{
   echo $quantity.' JAME shares, ';
}
else
{
echo 'Your Basket it Empty';
}
$total_cost = number_format($total_cost,2);
echo ' and it will cost you $'.$total_cost; 

$insert = mysql_query("insert into trades values ('NULL', 'JAME', '".$_POST['quantity']."', '.$total_cost')")
or die("Could not insert data because ".mysql_error());
ob_end_flush();
?>

<br>
<br>
Visit<a href="index.php">Your Portfolio</a> to see your purchases.

</body>
</html>

MY ERROR ----------

Are you sure you want to buy shares in JAME? (Total Below)

You have selected: 10 JAME shares, and it will cost you $500.00Could not insert data because Column count doesn't match value count at row 1

tomhath

You have 'NULL' in quotes, so mysql thinks you mean the string 'NULL', instead of NULL

Try it this way, but use your column names and give it all the values you want to insert.

$insert = mysql_query("insert into trades (COL2, COL3, COL4, COL5) values ('JAME', '".$_POST['quantity']."', '.$total_cost', '???Where is Jimbo??')")
or die("Could not insert data because ".mysql_error());