Bug #18172: Mysql_query function RLIKE and REGEXP

From: r.denis@bell.ca Operating system: Freebsd/Linux PHP version: 4.2.1 PHP Bug Type: MySQL related Bug description: Mysql_query function RLIKE and REGEXP I am not certain what the issue is however, When mysql_query is called in the following manner it fails to return all regexp occurances of the the given variable; Both REGEXP and RLIKE fail! $query2="select * from report WHERE users REGEXP '$zcntlogin'"; //$query2="select * from report WHERE users RLIKE '$zcntlogin'"; This is, or from my understanding should be the equivalent of connecting to the mysql server and executing the command: select * from report WHERE users RLIKE 'firstname.lastname'; //which works! In my script $zcntlogin is set through pam_smbd and mod_auth_external <?php if (!isset($PHP_AUTH_USER) || !zcntlogin) { header("WWW-Authenticate: Basic realm=\"Bell Domain\""); header("HTTP/1.0 401 Unauthorized"); echo "Text to send if user hits Cancel button\n"; exit; } else { $zcntlogin =$PHP_AUTH_USER; } ?> Hopefully that helps. Cheers, Rob -- Edit bug report at http://bugs.php.net/?id=18172&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18172&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18172&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18172&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18172&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18172&r=support Expected behavior: http://bugs.php.net/fix.php?id=18172&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18172&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18172&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18172&r=globals