I'm trying to query sql to post all new users on my site to the index page. This string:
$sql = "SELECT COUNT(id) FROM users WHERE activated='1'";
keeps returning this error:
Parse error: syntax error, unexpected T_LNUMBER in /home/******/********/index.php on line 14
I have tried canceling out as suggested on php.net using:
$sql = SELECT COUNT(id) FROM users WHERE activated=\'1';
and receive:
Parse error: syntax error, unexpected $end in /home/******/********/index.php on line 35
because now it's incomplete. What's the issue? All suggestions I have found online are not working.