Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by sirugo
-
Find the id of the max-value
The query now runs 160 times faster (less than a second)! Thanks again. -
Find the id of the max-value
Of course...it should have crossed my mind. I'll try it out and report back. Thanks. -
Find the id of the max-value
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? -
Find the id of the max-value
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 ) -
-
Find the id of the max-value
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... -
Problem after upgrade
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... -
Error reporting after upgrade
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... -
Error reporting after upgrade
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? -
Error reporting after upgrade
OK, I was doing the reverse: I have a file to which I'm including the reporting commands. Isn't that the same? -
Error reporting after upgrade
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... -
Error reporting after upgrade
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 -
Error reporting after upgrade
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... -
Error reporting after upgrade
..or forgotten semicolons. I only get a blank page. The error_reporting level is set to 2047 (or even tried 4096) but still nothing. -
Error reporting after upgrade
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...
