I had this select query which worked fine until I performed an inner join.
$id = (int) $_GET['id'];
$data = mysql_query("
SELECT
events.start_datetime,
events.EVENT_NAME,
events.START_TIME,
events.END_TIME,
events.VENUE_LOCATION,
venues.VENUE_NAME
FROM
events
INNER JOIN venues
ON events.VENUE_LOCATION = venues.ID
WHERE
id = ".$id) or die(mysql_error());
The $id
variable is so that the query loads data from a row depending on the url (ie: page.php?id=1).
Any idea what's wrong? Thanks