can variable be used once? Help Needed

[ceanth]

i have a script for a cart, session variables are passed along and when an item is added to the cart, i check to see if the item is already not in the cart, so i use "c_no" to check as the cart has a link to the customer.

Now if the item is not in the cart, i want to add, but if i use the c_no again it wont add to cart.

$result = mysql_query("select * from cuscart where custId = '$c_no' and productId = '$product_no'");
$row = mysql_fetch_row($result);
$numRows = $row[0];

if($numRows == 0)
{
// This item doesn't exist in the users cart,
// we will add it with an insert query

$sql = mysql_query("INSERT INTO cuscart (cartId, custId, productId, qty) VALUES('NULL', '$c_no', '$product_no', '$qty')");

The first query works but the second adds to the database ok but doesnt add the $c_no, anyone have any suggestions as to why this is happening?

[ceanth]

umm ok i had the value as varchar for customer id in the cart table , but now i have changed that to INT i get a 0 for the cust_no in the cart table 😕 😕 😕

[HalfaBee]

Try doing a little debugging.

print "$c_no";

and see what comes out.

HalfaBee

[ceanth]

yup i did that, i posted it in the coding section as i think its a coding problem, take alook i have explained it a little more

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10248984

thanks