By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,642 Members | 1,674 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,642 IT Pros & Developers. It's quick & easy.

Posting to SQL table problem?

P: 3
I recently had a program written in php for e-commerce, but there seems to be a problem with the posting of the cart id to the SQL table. The designer is no longer available for questions, so I had hoped to get some help here. I have a brief knowledge of php, but just cant seem to track the problem down.

There are two tables used for the cart:

store_shopping_cart and
store_shopping_cart_items

Everything works fine until you try to add an item to the cart. It tries to enter a null value into store_shopping_cart_items for the column shopping_cart_id

The shopping cart id obviously cannot be null or there could be major confusion between different customers.

I know you need more information and to look at the code to give me an answer, but there are many dependent php files (classes.php,common.php, etc.) I didnt want to post them all here and waste a bunch of space..

Could some1 contact me and help me track this problem down? I'd like to get the site up and working asap because its a much better design than our current site.

Thanks
TimmyC
TimmyC@5thavenuebling.com
Feb 2 '07 #1
Share this Question
Share on Google+
3 Replies


Motoma
Expert 2.5K+
P: 3,235
I recently had a program written in php for e-commerce, but there seems to be a problem with the posting of the cart id to the SQL table. The designer is no longer available for questions, so I had hoped to get some help here. I have a brief knowledge of php, but just cant seem to track the problem down.

There are two tables used for the cart:

store_shopping_cart and
store_shopping_cart_items

Everything works fine until you try to add an item to the cart. It tries to enter a null value into store_shopping_cart_items for the column shopping_cart_id

The shopping cart id obviously cannot be null or there could be major confusion between different customers.

I know you need more information and to look at the code to give me an answer, but there are many dependent php files (classes.php,common.php, etc.) I didnt want to post them all here and waste a bunch of space..

Could some1 contact me and help me track this problem down? I'd like to get the site up and working asap because its a much better design than our current site.

Thanks
TimmyC
TimmyC@5thavenuebling.com
Welcome to The Scripts, TimmyC.
What type of SQL are you using?
You will need to set the column to be Autoincrement (MySQL) or Identity (MSSQL).
Feb 2 '07 #2

P: 3
Thak you for the reply.

I do believe it to be an autoincrement problem. Do you think the difference between postgreSQL and MySQL would create the problem?

The cart_id table posts correctly, its just when it tries to reference the cart_items it pulls a null value. Would changing the column from not null help?

just a few thoughts..

TimmyC
Feb 3 '07 #3

Motoma
Expert 2.5K+
P: 3,235
The cart_id table posts correctly, its just when it tries to reference the cart_items it pulls a null value. Would changing the column from not null help?
Yes.

Sorry for such a short answer.
Feb 3 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.