Super bizarre changing variable!!

From: Date: Thu, 04 Oct 2007 15:50:09 +0000
Subject: Super bizarre changing variable!!
Groups: php.general 
Request: Send a blank email to php-general+get-262753@lists.php.net to get a copy of this message
I'm running the following code: $query3 = "DELETE FROM table1 WHERE referer=$referer ORDER BY creation LIMIT $numtodelete"; $result3 = mysql_query($query3); $string = "$total found, $n kept, $numtodelete extras removed ($query3)"; $x = mysql_query("insert into table2 (friend_id,data) values ($referer,'$string')"); I created the table2 log file just so I could see what the hell is going on. Here is a typical entry in table2: FRIEND_ID = 8388607 DATA = 908 found, 100 kept, 808 extras removed (DELETE FROM table1 WHERE referer=69833818 ORDER BY creation LIMIT 808) Notice that the value in FRIEND_ID, which was set with $referer, is DIFFERENT than the value of $referer shown in DATA! How the flying f*&^%k is this possible??? I've been tearing my hair out for 3 days over this. Almost all records show 8388607 in that FRIEND_ID field. Once in a blue moon, a different value is shown, which does match the value in DATA. So it's displaying this erroneous behavior 95% of the time but not always.

« previous php.general (#262753) next »