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