MySQL Query worked in 3.23 but not 4.1 (Help Requested)

[WetWired]

Originally Posted by hurrican

Well, It worked one time, and not the next time. I run this via cron script - did not include entire cron script, just the delete statement.. The problem I have is that it will not remove anyone.. I never put it into use on my real db yet. I had to end up recompiling MySQL/PHP/Apache -- Did I maybe not include something I should have when I compiled PHP?? If so, my entire ./configure is below -- thanks for any help, again!

My exact DELETE query is this:

PHP Code:

mysql_query("DELETE FROM user WHERE lastvisit ".(time() - (60 * 60 * 24 * 487))." AND usergroupid IN (2, 3, 10, 11)", $db); 


'./configure' '--with-apxs2=/etc/httpd/bin/apxs' '--with-freetype-dir=/usr/local' '--with-png-dir=/usr/local' '--with-gd=/usr/local/gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-jpeg-dir=/usr/local' '--with-openssl' '--with-png' '--with-xml' '--with-zlib' '--enable-track-vars' '--with-kerberos=/usr/kerberos' '--with-mysql' '--enable-memory-limit' '--enable-calendar'

You need a condtional ("<"?) for the lastvisit, and parenthesis arround each condition couldn't hurt.