$referer is always an integer, 6 to 10 digits long.
To clarify: the value of $referer is changing between line 1, where
$query3 is being set, and line 4, where it's being written into my
debugging log table2.
I can't see any way that $referer could be different in those two
places.
On Oct 4, 2007, at 9:10 AM, Colin Guthrie wrote:
Brian Dunning wrote:
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.
I've been trying to follow your code here but the results you are
showing are in no way related to queries you are running.
You've said "FRIEND_ID = 8388607", but all you are saying here is that
you've picked a random row from your table2 and it's not the same
as the
referer in your $string value.... this could easily be the case. You
should echo out both $query3 and string and the other query you run
inline and compare these three values for inconsistencies...
PS I really home the value stored in $referer has already been
properly
escaped with e.g. mysql_real_escape_string.....
Col
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
