why doesnt this work?

<?php
session_start();

include("db.php");
echo ($_SESSION["cust_no"]);

at the start of the script, this displayes the value fine

$sql = mysql_query("INSERT INTO cuscart (custId, productId , qty)
VALUES('($_SESSION["cust_no"])', '$product_no', '$qty') ");

This adds to the database but not the session value, the table was created as followed:

create table cuscart
(
cartId int not null auto_increment,
custId VarChar (50),
productId VarChar (50),
qty VarChar (50),
primary key (cartId)
)

use:
values ($_SESSION[cust_no]) ...
and don't use 'var' if field is int

You should try this.

$sql = mysql_query("INSERT INTO cuscart (custId, productId , qty) 
VALUES('{$_SESSION["cust_no"]}', '$product_no', '$qty') ");

HalfaBee

strange, both methods worked, but TTT why did the other one at the top display? and what do u mean by dont use 'var'?