jbrill Posted November 15, 2007 Share Posted November 15, 2007 Hey guys, i'm currently trying to code my own shopping cart and have run into a little snag, I'm hoping someone here can help me. i have two tables in my database which i need to comunicate between. The tables are as follows: products - this stores the product information (productnumber, productname, price) cartitems - this stores the things the user has added to cart. basically, what i need to do is run a query that will search through the cartitems table and find the correct info from the products table. so lets say in my cart items table i have a productid that is "1" i need to search the products table and find the item where the id="1" and display the productnumber and productname. how would i go about doing this? Quote Link to comment https://forums.phpfreaks.com/topic/77502-solved-mysql-query-questionm-please-help-me/ Share on other sites More sharing options...
pocobueno1388 Posted November 15, 2007 Share Posted November 15, 2007 Please mark this as solved as it was solved on the PHP board. Quote Link to comment https://forums.phpfreaks.com/topic/77502-solved-mysql-query-questionm-please-help-me/#findComment-392341 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.