Re: Inserting Data into MySQL database

> 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 Try; "show create table _tablename_; from inside the mysql client. It will display what values are being inserted as a default. Remember: null and an empty string are not the same thing. David