I'm currently experimenting with a form that let's me add data into my database. Looks something like this:
if ($submit)
{
if ($action==insert)
{
$sql="INSERT INTO tel_episodes VALUES('','$ProgramID','$Episode','$Season','$EN','$PN','$OAD','$Synopsis','$Pic')";
$result=mysql_query($sql,$db);
echo "<B CLASS=header>Episode Submitted!</B><P>\n";
echo "<CENTER><A HREF=$PHP_SELF?programID=$ProgramID><B>INDEX</B></A></CENTER>\n";
}
else
{
$sql="UPDATE tel_episodes SET ProgramID='$ProgramID', Episode='$Episode', Season='$Season', EN='$EN', PN='$PN',
OAD='$OAD', Synopsis='$Synopsis', Pic='$Pic'
WHERE EpisodeID=$EpisodeID";
$result=mysql_query($sql,$db);
echo "<B CLASS=header>Episode Edited!</B><P>\n";
echo "<CENTER><A HREF=$PHP_SELF?programID=$ProgramID><B>INDEX</B></A></CENTER>\n";
}
}
Everything's been working grand, but I just noticed something that kinda bugs. If I leave text values empty in my form and submit it, it leaves those fields blank in my database, which is what I want. However, if I leave numeric values blank, it inserts zeroes into my database. For INT fields, it inserts a "0" and for DATE fields, a "0000-00-00". So uh...how come?
