Code: Select all
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
$facebook = $_GET['facebookuser'];
$ver = "/^[\d]*$/";
if (
(isset($_GET["MM_update"]))
&& ($_GET["MM_update"] == "facebook")
&& ($_GET['facebookuser'] !="")
&& (preg_match($ver, $facebook))
){
if ((isset($_GET["MM_update"])) && ($_GET["MM_update"] == "facebook")) {
$updateSQL1 = "UPDATE businessdetails SET facebookid='$facebook' WHERE userid='$uid' AND recoentryid = '$ent'";
mysql_select_db($database_recommendingpeople, $recommendingpeople);
$Result2 = mysql_query($updateSQL1, $recommendingpeople) or die(mysql_error());
}
}However the number inputted into my database is 2147483647UPDATE businessdetails SET facebookid='100000074108584' WHERE userid='3' AND recoentryid = '1'
What's going on? Why won't it update the correct number - I've tried it all ways I can and it always inputs the second number - I have no idea where that number comes from - I just can't get $facebook into my db. Grateful for any help on this - I thought this should be an easy one for me and I would like to know why it isn't.