Untitled

Number in PHP form being saved as a random number in mySQL DB

$sql = mysql_query("UPDATE `customer` SET `f_name` = '$fname',`l_name` = '$lname',`email` = '$email',`number` = '$number' WHERE `c_id` = '$id'");

       

CREATE TABLE Customer(

    c_id        INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,

    f_name      VARCHAR(50) NOT NULL,

    l_name      VARCHAR(50) NOT NULL,

    email       VARCHAR(100) NOT NULL,

    number      INTEGER,

    date_joined DATE NOT NULL CHECK (date_added <= now())

);

       

mysql> ALTER TABLE Customer MODIFY number BIGINT;