Bug #18172 Updated: Mysql_query function RLIKE and REGEXP

ID: 18172 Updated by: mfischer@php.net Reported By: r.denis@bell.ca -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Freebsd/Linux PHP Version: 4.2.1 New Comment: In PHP 4.2.0, the 'register_globals' setting default changed to be off. See http://www.php.net/release_4_2_0.php for more info. We are sorry about the inconvenience, but this change was a necessary part of our efforts to make PHP scripting more secure and portable. Previous Comments: ------------------------------------------------------------------------ [2002-07-04 23:08:50] r.denis@bell.ca 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 this bug report at http://bugs.php.net/?id=18172&edit=1