mysql Error -> used phpmyadmin

chobo · 12-26-2007, 04:28 AM

Error

SQL query:

(
) ORDER BY `User` ASC , `Host` ASC

MySQL said: Documentation
#1064 - 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 ') ORDER BY `User` ASC, `Host` ASC' at line 1

how to fix it

thanks a lot

chobo

johnvoisey · 12-26-2007, 03:11 PM

I think the problem must be in your select statement and those brackets

Can you post more of the query ?

I ask because if I do THIS on the mysql 5 in slackware 12

use mysql
select user,host,password from user order by user asc, host asc;

That works

So does

select user, host, password from user order by 'user' asc, 'host' asc;

hope this helps

chobo · 12-26-2007, 11:26 PM

oh ok

have worked too

mysql> select user,host,password from user order by user asc, host asc;

----+----------------------+-------------------------------------------+
11 rows in set (0.00 sec)

thanks a lot

johnvoisey