| dpgirago@mdanderson.org 2006-06-17, 8:04 am |
|
> 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
|