Busy — Sun, 01 Sep 2002 00:06:21 +0000

Thanks Mark, I upgraded MYSQL and now it works

Busy — Tue, 27 Aug 2002 23:01:17 +0000

Thanks everyone, I'll try update it,
I test on windows but upload to unix, It's not an important page so if upgrading doesnt help might cheat it like Mark mentioned

*maybe I should just get rid of windows :D*

ROB — Tue, 27 Aug 2002 07:07:24 +0000

if installing the latest version doesnt help, i'd say join the devlist and see if you cant get some answers there.

Mark Hensler — Tue, 27 Aug 2002 05:27:00 +0000

Alright, I had a similar problem running mysql on a Win box. It's been a few years now. Some queries would crash mysql on my win box, but work perfectly once I uploaded them to a unix box. Very odd.

Check to make sure you have the latest version. If that doesn't fix it, you'll probably have to keep the ORDER BY clause and fake the LIMIT clause using PHP and a loop structure.

Busy — Mon, 26 Aug 2002 23:11:43 +0000

yep win98 se, apart from this one thing havent had any other problems

Mark Hensler — Mon, 26 Aug 2002 05:56:36 +0000

Are you running mysqld on a windows box?

Busy — Mon, 26 Aug 2002 05:16:45 +0000

same thing, crashs mysql, heres the illegal op details if you can undertsand them:

MYSQLD-OPT caused an invalid page fault in
module MYSQLD-OPT.EXE at 018f:0045dbee.
Registers:
EAX=00000000 CS=018f EIP=0045dbee EFLGS=00010287
EBX=0382fb73 SS=0197 ESP=0179f73c EBP=69e28001
ECX=00000001 DS=0197 ESI=00a04100 FS=83ef
EDX=00a91228 ES=0197 EDI=00000000 GS=0000
Bytes at CS:EIP:
39 11 75 3b 33 d2 8a 51 14 f6 d2 33 db 81 e2 ff
Stack dump:
705f6e6d 00000005 00a94cc0 0382fb73 0045da27 00a04100 00a94cc0 00000005 00000000 00a042f0 014457c0 00a04100 00000000 0045dc61 00a042f0 00a04100

Mark Hensler — Mon, 26 Aug 2002 02:57:37 +0000

Doesn't matter... a quote from the user comments:

Quote: Since exit is a language construct and not a function, doing:

exit;

without the parenthesis is legal.

Busy — Mon, 26 Aug 2002 00:05:26 +0000

is it exit or exit() ?

zollet — Sun, 25 Aug 2002 19:44:03 +0000

Just do..

<?php
$result = mysql_query(\"SELECT pid, phits FROM jokes order by phits desc limit 0,30\");
echo mysql_error();
exit;
?>