Faqts : Business : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

10 of 21 people (48%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

mysql server is down each time i use ORDER BY in a query - an idea ? Thank You

Nov 22nd, 2008 14:05
haytham ali, dman, The Guru, Curtis, pier carlo, http://msryat.org


I have noticed that it matters where you put the ORDER BY in a query, 
it 
needs to be after full select statement, for example:
SELECT * FROM myTable ORDER BY date

Give the SQL that you are using and I'll see what I can do.

[added by The Guru]

You might like to share the query with us so that we can look into 
where the things are going wrong.

The Guru

http://6rb.com
http://fr7.com
http://dir.msryat.org
http://6ef.com
http://forums.msryat.org
http://www.arabcar.com
http://www.alshalah.com