$sql = mysql_query("SELECT naam,rank,rankimg,rankex,dia_online, CASE WHEN TIMEDIFF(now(), online) > '00:03:00' THEN 'nee' ELSE 'ja' END AS status, CASE WHEN TIMEDIFF(now(), dia_online) > '00:00:05' THEN 'nee' ELSE 'ja' END AS d_status FROM leden WHERE geactiveerd = 'ja' ORDER BY rank,ranklvl") or trigger_error(mysql_error());
$sql = mysql_query("SELECT naam,rank,rankimg,rankex,dia_online, CASE UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(online) > 180 THEN 'nee' ELSE 'ja' END AS status FROM leden WHERE geactiveerd = 'ja' ORDER BY rank,ranklvl") or trigger_error(mysql_error());
?>
Error:
Notice: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN 'nee' ELSE 'ja' END AS status FROM leden WHERE geactiveerd in /data/members/paid/r/o/robertdeiman.net/htdocs/mebus/members.php on line 81
CASE,THEN,ELSE,END,AS dit werkt toch wel op sql versie: 3.23.57?
$sql = mysql_query("SELECT naam,rank,rankimg,rankex,dia_online, CASE WHEN UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(online) > 180 THEN 'nee' ELSE 'ja' END AS status, CASE WHEN UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(dia_online) > 5 THEN 'nee' ELSE 'ja' END AS d_status FROM leden WHERE geactiveerd = 'ja' ORDER BY rank,ranklvl") or trigger_error(mysql_error());
