[Resolved] MySql Query to isolate AOL email addys

[showman]

Hi,

Could someone tell me what is wrong with the syntax of this query. I'm trying to check all of the member records in a table, and count how many have @aol.com addresses.

I keep getting a syntax error.

error=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 '(*) FROM mem_data where mid(Email, instr(Email,'@

$query = "SELECT count ( * )
FROM member_data
where mid(Email, instr(Email,'@') +1) = 'aol.com'
";

Any help would be greatly appreciated..
doug

[LordShryku]

Move your count in from count ( ) to count()

[showman]

That is how I originally had it and got the same syntax error..

I spaced it out to send to a friend on MSN IM, so it wouldn't convert it to a star.. Sorry, forgot to change it back before posting it here.

$query = "SELECT count (*)
FROM mem_data
where mid(Email, instr(Email,'@') +1) = 'aol.com'
";

[showman]

Forgot to post the resolution.. It was simple

$query = "SELECT count (*)
FROM mem_data
where mid(Email, instr(Email,'@') +1) = 'aol.com'
";

there is a space between the count and the (*) that doesn't belong there..

Thanks
doug