[Select Failed - count] error from Tutorial "Login Using Flash MX, PHP, and MySQL"

I just recently used the Tutorial [size=4][color=#003366]Login Using Flash MX, PHP, and MySQL, [/color][size=2][color=#000000]but after hooking everything up, I found I was getting this error…
[size=4][size=2][color=#000000]Select Failed - count… looking at the coding from the PHP file, I noticed that the coding had the alter code if failed, but when looking at it, I have not a clue to what is wrong.

$queryb=“SELECT COUNT() FROM auth";
or die(“Unable to connect to SQL server”);
mysql_select_db(“database”) or die(“Unable to select database”);
$numusers=mysql_query($queryb) or die (“Select Failed - count”);
[size=4][size=2][color=#000000] I did not put in the server name, name, password, etc. for protection purposes, but, looking at the variable $queryb="SELECT COUNT(
) FROM auth”, that is not working… is it because I don’t have this SQL table in the right place in my site? I thought it was in the mysql file, but I could be wrong… please help, Thank You in return…[/color][/size][/size]
[size=4][size=2][color=#000000](coding of the table)[/color][/size][/size]
[size=4][size=2][color=#000000]CREATE TABLE auth (
DEFAULT ‘0000’
username varchar(20),
userpassword varchar(20),
PRIMARY KEY (userid)