auto_increment

[inusrat]

Hi,

I have a table in which I have 6 fields, my primary key called order_no is bigint and it is also auto_incrment.

My insert statement is like the following. It does not work

$resultcat= mysql_query("insert into shopping_cart values ('$cart_id','$productid','$name','$quantity','$price' )")

Now If take my order_no (auto increment) key out, it works, what I am doing wrong in my insert statement?

Thanks

http://www.786Marriage.com

http://www.amasspharma.com

http://www.ambdex.com

 

[towerbase]

Your insert statement only has five fields whilst your table has six fields.

Assuming that your auto_increment field, order_no, is the first column in the table then your insert statement should look like:

$resultcat= mysql_query("insert into shopping_cart  values (0,'$cart_id','$productid','$name','$quantity','$price' )")

MySQL will replace the 0 with the appropriate value for order_no when it inserts the record into your table.


Andrew
Hampshire, UK

 

[cdlvj]

or in your insert, identify the db fields that you want to populate, ignore the autoincrement.

keep in mind that on some of the versions, auto-increment does not work in multitasking situations.

 

[inusrat]

thanks a lot i will do that..............

http://www.786Marriage.com

http://www.amasspharma.com

http://www.ambdex.com