Inserting Data into MySQL database

["Girish Agarwal" <gagarwal@xxxxxxxxxxxxx>]

Hi All,
         I have a table in mySQL database 5.0 the structure of which is as
follows
         ssno INT 9,
         lname VARCHAR(15) NOT NULL,
         fname VARCHAR(15) NOT NULL,

        I am inserting the values using
       $query = "insert into student (ssno,lname,fname) VALUES
('".$student['ssno']."','".$student['lname']."','".$student['fname']."')";
       This Query is working Fine but the only Problem I have is that if the
lname and fname values are NULL then how come it does not return an
      error but instead adds the record into the database. Is it because I
am not passing the values properly. Please Help

Thanks,
Girish

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php