The following example fails to produce any results.
$cxr_sql=mysql_query("select username from game g join user u
on g.cxrId = u.id
where g.ticket='" . $gameTicket . "'");
$row=mysql_fetch_array($cxr_sql);
$cxr=$row['username'];
However, this (same code) works on an other system. And the sql produce the expected result when executed in mysqlworkbench on the system that fails. So why is it suddently empty when executed from PHP.
Driving me f23423 insane!!!
PS. i have echo'ed the sql statement to the screen. It performs fine in workbench????