[snip] Apparently, "SELECT COUNT (*) FROM ...." is not valid syntax according to mysql ? where as "SELECT COUNT(*) FROM ...." is ? [/snip]
The syntax is the same for all function contained in parentheses in MySQL, and as far as I can recall, in database systems other than MySQL (Oracle and M$SQL Server come to mind)...there should be no space between the function call and the opening parentheses. I know that ANSI-92 SQL and ANSI-99 SQL do not have this requirement, but I think that the MySQL folks may have looked closely at other programming languages and found that function names are almost immediately followed by the opening parentheses (is one just a parenthesi? :) ). Is this a problem? Jay sql, mysql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php