Duke Posted August 23, 2014 Share Posted August 23, 2014 Hi RE: Chapter 9 cart.php... the following code.. //display carts contents $r = mysqli_query($dbc, "CALL get_shopping_cart_contents('$uid')"); if(!$r) echo mysqli_error($dbc); is causing this error on page Unknown column 'c.product_id' in 'on clause' I went over my stored procedure...could not find an error..resorted to copy and pasting stored procedure from book download.....My question is could my error still be in this stored procedure? Thank you Link to comment Share on other sites More sharing options...
Duke Posted August 24, 2014 Author Share Posted August 24, 2014 I Found my error.....My error was that I did not have a "product_id" column in my CARTS Table Thank you. Link to comment Share on other sites More sharing options...
Larry Posted August 25, 2014 Share Posted August 25, 2014 Ah...that would do it! Kudos for figuring it out and thanks for letting us know. Link to comment Share on other sites More sharing options...
Recommended Posts