Search results for query: *

The query now runs 160 times faster (less than a second)! Thanks again.

Of course...it should have crossed my mind. I'll try it out and report back. Thanks.

I'm back. I first used it on a table with "not so many rows" and it went well. I then tried it on a table with 4000 rows and it goes terribly slow: 82 seconds to extract 300 rows out of 4000. Is there a faster way to do this?

OK, I finally solved it using a subselect. It went wrong on the final WHERE, but now it works SELECT this, that FROM table t1 WHERE column1 = ( SELECT MAX(t2. column1) FROM table t2 WHERE t1. column2 = t2.column2 AND t1.column3 = t2. column3 )

Have a look here

I can't be the first one with this problem: I simply want to find the row-ids that hold the MAX-values grouped by specific column names. Instinctively I would use: SELECT ix, column1, MAX(column1) FROM table GROUP BY column2, column3 but this does not even give the same values of column1 and...

I have been running MySQL 3.23 for some years. Now we upgraded to 5.0 and I'm experiencing som problems. Earlier the following query was executed flawlessly: SELECT col1, col2, table2.col3 FROM table1, table2 LEFT JOIN table3 ON table1.someid = table3.someotherid but now this query triggers...

I can't turn the on and off in the php.ini all the time. I'mdeveloping five apps at the same time and all of the old ones constantly need to be changed or updated. There must be a way to get those warnings back without having to tamper with the php.ini all the time. I'll try to turn them on then...

OK, but there's a security issue with displaying errors. If I change it in the php.ini to display errors, can I hide the error messages at runtime?

OK, I was doing the reverse: I have a file to which I'm including the reporting commands. Isn't that the same?

It's not set in php.ini but I'm setting it in runtime during the developing process: ini_set('display_errors', 1); ini_set('error_reporting', 2048); ini_set('mysql.trace_mode', 1); After setting the values I've checked that they get properly set and they do. Error reporting works but not the...

Actually I'm running the Apache server and the server is also new with a new .htaccess file. I found this URL. Maybe I need to change the .htaccess file? http://forum.dreamhosters.com/programming/45191-php-hiding-full-paths-in-error-messages.htm

I tried to change to E_STRICT. I "forgot" the last curly brace in the script and I get a blank page. With the previous PHP-version (can't remember exactly which) I got a weird message saying that "unexpected $" or something like that. It always reminded me to close the braces. Also a forgotten...

..or forgotten semicolons. I only get a blank page. The error_reporting level is set to 2047 (or even tried 4096) but still nothing.

After upgrading PHP I'm not feeling comfortable about how the error reporting works. With the previous version I got reports caused by errors like: if($a > 1) { } (empty curly braces) or forgotten curly braces at the ebd of the script These don't show up anymore which leads to a never...

I have a php script that produces text files. A directory in the web folder is assigned for this reason. Someone said that the directory must must be given write permission for "all" for it to work. Is it true? Is there no way to turn php into a "owner" who has those permissions which limits...

Have you connected to the database, using mysql_connect ? Have you chosen the correct database using mysql_select_db?

Oops. Suddenly it worked. Dunno what I made differently... I'll let you know if things change. Sorry.

I'm overriding the current settings of php.ini using ini_set like this in the developing phase: ini_set('display_errors', 1); ini_set('error_reporting', 2047); ini_set('mysql.trace_mode', 1); printf("<P>%s%s", $ffr); $msc = mysql_connect("localhost", "webuid", "webpwd")...

Because the users use both Explorer and Firefox and the Explorer-cookie won't be available to Firefox. So I must do it for both applications to have the users logged in automatically no matter which browser they're using.