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? 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. 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
Archived
This topic is now archived and is closed to further replies.