php shutting down

Anon

I have install win-php4 win-apache and win mysql, the mysql is working fine,ie I can create db's and query them from dos. The php will run all the scripts that don't contain any mysql functions, but once they do i get a php:this program has performed an illegal action pop-up which leads to an internal server error page in the browser. I am sure the problem is with php but don't know how to solve it.Any help would be appreciated

Anon

did you uncomment the line that says extension=php3_mysql.dll ?

try doing that by removing the ; in the beginning of the file .. you will find this line on php.ini

Anon

That's only for PHP3, in PHP4 MySQL support is built in totally, so there's no need for this. I think the problem must be in php.ini.

I presume you've put php.ini in the c:\windows directory?

If non-MySQL scripts work ok, I'm not quite sure what to suggest. Are you making sure that MySQL is running in the background befire you try to run any scripts?

One possibility is that your PHP script is doing something funny. In every Windoes machine I've seen MySQL crashes when you do a SELECT with an ORDER BY.

Can you post any scripts you're using?

Can you describe in more detail what you did to install everything?

Anon

"One possibility is that your PHP script is doing something funny. In every Windoes machine I've seen MySQL crashes when you do a SELECT with an ORDER BY."

mySQL does not crash on my win98se dev machine, and I used "ORDER BY" very frequently. This should not be the case at all with mySQL on win32.

Anon

hmmm, what version of MySQL are you running?

Anon

3.23.24-beta on win98se, using the "-opt" binary. Trust me I am complete newbie to mySQL, I am just porting over from NT (ASP/SQL Server and/or Acccess 2000 in some cases), to mySQL/PHP (switching to a linux machine for my hosting). I was running an older version and did not encounter any problems with that either. (Besides the ones I created) I would be really surprised to find out that this is indeed a well known bug/issue, and I would think that if it is you should definately contact the listerv and/or mySQL. (Unless I happen to be using a version that it was fixed in, I did have a 3.22 version prior to this). Interesting nontheless, perhaps it has problems with very large recordsets returned?

Anon

I have 3.22.33, and I did look around the mailing lists for a bug report. I found one post which seemed to have the same problem. If the same bug appeared in the next versio I install then I would report it. It was weird that it was exactly the same on 4 separate win 98 boxes. 3 were with Apache, 1 with PWS.
I don't think the size of recordsets was the problwm, they were very small. The exact same scripts work on my Linux ISP perfectly!

Anyway I don't think that is the problem here.