MySQL: Error in query???

[Anon]

Hi,

what is wrong with this following query to a MySQL 3.23.14 database running under Windows 95 and 98 (distr. from Firepages)

"SELECT * FROM table WHERE (category='$cat' AND show='$part' AND action='none') ORDER BY manufacturer LIMIT 0,10"

It crashes my sql server, though it seems ok by the manual for MySQL. If I do the same without the 'ORDER BY manufacturer', it works, same when I don't 'LIMIT' my result.

Is there an error in the query, a possible workaround, or is it simply a bug?

Thanks, Joerg
www.surfspot-magazine.com

[[deleted]]

Looks like a bug.
Windows9x was never the platform to run anything serious on. Try win2k or better, a real OS like Linux.