ShaolinF Posted February 1, 2008 Share Posted February 1, 2008 Hi Guys, I have 3 tables and I want to derive certain columns from all three of them. See the tables below (The text highlighted in bold red are the columns I want to extract): users table: userid, name, contactNo, email, gender purchase table: purchaseid, userid, eventid, noOfTicketsPurchased, totalPrice, process_timestamp, pp_payment_status event table: eventid, eventName, TicketsOnSale, TicketPrice, setevent Quote Link to comment https://forums.phpfreaks.com/topic/88958-solved-grab-data-from-different-tables/ Share on other sites More sharing options...
amites Posted February 1, 2008 Share Posted February 1, 2008 You would do well to study joins you can find a great starting point at http://www.tizag.com/mysqlTutorial/mysqljoins.php if you come up with some code and have trouble getting it working post what you have and I'd be happy to help you Quote Link to comment https://forums.phpfreaks.com/topic/88958-solved-grab-data-from-different-tables/#findComment-455611 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.