Hi Brian,
Thursday, October 4, 2007, 4:50:09 PM, you 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.
What data type do the referer / friend_id columns have in MySQL? int?
tinyint? etc
Also show all of your code - there is no way that the value changes
between lines 1 and 4 in the code above, which means you've missed
something out (probably for post brevitys sake)
Cheers,
Rich
--
Zend Certified Engineer
http://www.corephp.co.uk
"Never trust a computer you can't throw out of a window"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
