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
<!-- w --><a class="postlink" href="http://www.surfspot-magazine.com">www.surfspot-magazine.com</a><!-- w -->
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
<!-- w --><a class="postlink" href="http://www.surfspot-magazine.com">www.surfspot-magazine.com</a><!-- w -->