HI Folks,
The code below keeps generating the error, I have a wordpress site using the same db which connects fine using exactly the same credtials. Any ideas folks?
Many thanks
<?php
require("config.php");
$link = mysql_connect("$database_host","$database_user","$database_pass") or die(mysql_error());
mysql_select_db($database_name);
$query = "SELECT id,title,start, DATE_FORMAT(start, '%Y-%m-%d %H:%i' ) AS startDate, end, url FROM events ORDER BY startDate DESC";
$result = mysql_query($query) or die(mysql_error());
$arr = array();
while($row = mysql_fetch_assoc($result)){
$arr[] = $row;
}
echo json_encode($arr);
?>