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…
[/color][/size][/size]
[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";
mysql_connect(“mysql.server.com”,“name”,“password”)
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”);
$numuser=mysql_fetch_array($numusers);
?>[/color][/size][/size]
[size=4][size=2][color=#000000][/color][/size][/size]
[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][/color][/size][/size]
[size=4][size=2][color=#000000](coding of the table)[/color][/size][/size]
[size=4][size=2][color=#000000][/color][/size][/size]
[size=4][size=2][color=#000000]CREATE TABLE auth (
userid
int(4)
unsigned
zerofill
DEFAULT ‘0000’
NOT NULL
auto_increment,
username varchar(20),
userpassword varchar(20),
PRIMARY KEY (userid)
);[font=Arial]
[/font]
[/color][/size][/size]