Array values not represented in MySQL

[Heather]

I need to send the values of two arrays to a function to add them to the MySQL database. The customer id column in MySQL remains as '0'. Could anyone tell me why this is, here is the code I'm using:

if($add)
{
if($ShoppingCart)
$session = $ShoppingCart;

 $result = mysql_query(  "SELECT * FROM inventory WHERE product='$add'");
 $row = mysql_fetch_array($result);

 $result2 = mysql_query("select cust_id from customer where name='$cust_name'");
 $row2 = mysql_fetch_array($result2);

 $cart->add_item($table,$session,$row[product],1,$row[price],$row2[cust_id]);

}

function add_item($table,$session,$product,$quantity,$cost_price,$cust_id)
{
if($num_rows == 0)
{
$sql = "INSERT INTO $table (session,product,quantity,cost_price,cust_id) VALUES ";
$sql .= "('$session','$product','$quantity','$cost_price','$cust_id')";
mysql_query( "$sql");
}

Any ideas why customer id remains at '0'???????

[John_Canyon]

What does the table structure for "customer" look like.

Sounds to me like your table cust_id is not set to auto increment.

[tomhath]

My guess is that the select from customer didn't return any rows. Add a call to mysql_num_rows or check that you have a defined, non-zero value in $row2['cust_id'].

Also, you should have the column names in quotes; even though current releases of php let you be sloppy it's a bad practice:

$row2['cust_id'] instead of $row2[cust_id]