jcadima
5/28/2015 - 9:49 PM

INNER JOIN with id from URL and condition

INNER JOIN with id from URL and condition

<?php

	$sql = "SELECT DISTINCT ticket.ticket_name, ticket.ticket_price, ticket.sold, orders.fees, orders.event_id
			FROM ticket
			INNER JOIN orders  
			ON ticket.event_id = orders.event_id 
			WHERE ticket.event_id=". $_GET["id"] . " AND orders.fees!=0";