jcadima
8/28/2015 - 7:12 PM

INNER JOIN OF 3 TABLES

INNER JOIN OF 3 TABLES

<?php

$query = '
	SELECT order_tickets.order_id,ticket.event_id, order_tickets.ticket_tname as full_name, orders.address,
		orders.city, orders.state, orders.zipcode, orders.email,order_tickets.age, order_tickets.tshirt_size,  order_tickets.boxname,
		order_tickets.ticket_number, order_tickets.ticket_team_name, order_tickets.a1, order_tickets.a2,  order_tickets.a3,  order_tickets.a4,  order_tickets.a5,  order_tickets.a6,  order_tickets.a7, ticket.ticket_name, ticket.quantity, ticket.sold,
	    orders.amount, orders.fees, orders.date_added
	FROM  order_tickets
	INNER JOIN ticket
		ON order_tickets.ticket_id = ticket.ticket_id
	INNER JOIN orders
		ON order_tickets.order_id = orders.order_id
	WHERE orders.event_id = ' . $_GET["id"]  ;