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] 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 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! 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 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? 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! 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 Link to comment https://forums.phpfreaks.com/topic/23031-what-the/#findComment-104571 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.