dragonusthei Posted October 4, 2006 Share Posted October 4, 2006 Im having a really hard time with a problem.I want my shopping cart to check if the items added to cart is greater than those currently in stock i ran the query in phpadmin to see why it wasnt working but[img]http://img237.imageshack.us/img237/7674/phpweirdny2.jpg[/img] Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/ Share on other sites More sharing options...
HuggieBear Posted October 4, 2006 Share Posted October 4, 2006 What's the problem?RegardsHuggie Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104018 Share on other sites More sharing options...
ToonMariner Posted October 4, 2006 Share Posted October 4, 2006 his query returned a record where the stock was greter than the number requested!acoding to his pic anyway! Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104019 Share on other sites More sharing options...
HuggieBear Posted October 4, 2006 Share Posted October 4, 2006 Odd, as the same image says showing rows 0 to 0Hmmmm, Interesting! If you want to provide a sql dump of the table I'll load it into my version of phpMyAdmin and see if I get the same results.RegardsHuggie Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104022 Share on other sites More sharing options...
trq Posted October 4, 2006 Share Posted October 4, 2006 What field types are item_qty and item_stock? Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104026 Share on other sites More sharing options...
ToonMariner Posted October 4, 2006 Share Posted October 4, 2006 WELL SPOTTED!Looks like text to me - change them to ints! Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104029 Share on other sites More sharing options...
dragonusthei Posted October 5, 2006 Author Share Posted October 5, 2006 Thank you, changed them to ints and it works perfect :DThanks guys Quote Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104571 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.