Hey, I have this insert statement. It looks fine to me, however, it won't go through. Can anybody lend a pair of eyes?
<?php
mysql_connect("localhost","rtcstudent","student");
mysql_select_db("intranet");
$view = mysql_query("SELECT * FROM announcements ORDER BY time");
echo "<TABLE>";
while($messages = mysql_fetch_array($view)) {
echo "<TR><TD>Subject:</TD><TD>";
echo $messages['subject'];
echo "</TD></TR><TR><TD> </TD><TD>";
echo $messages['body'];
echo "</TD></TR><TR><TD> </TD><TD>";
echo "Posted by ".$messages['owner']. " at ".$messages[time];
echo "</TD></TR>";
}
if($submit){
mysql_connect("localhost","rtcstudent","student");
mysql_select_db("intranet");
$owner = 'Bryan';
$query = "INSERT INTO announcements (newsnum,subject,body,owner) VALUES (0,'$subject','$body','$owner')" or die("Error:");
$result = mysql_query($query);
}
?>
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE>
<FORM name="announcements" action="announcements.php" method="post">
<TR>
<TD>
Subject:
</TD>
<TD>
<Input type="text" name="subject" Value="" SIZE="50">
</TD>
</TR>
<TR>
<TD>
</TD>
<TD>
<Input type="text" name="body" Value="" SIZE="50">
</TD>
</TR>
<TR>
<TD>
</TD>
<TD>
<INPUT type="submit" name="submit" value="submit">
</TD>
</TR>
</FORM>
</TABLE>
</BODY>
</HTML>
and the schema:
CREATE TABLE announcements (
newsnum int(10) NOT NULL default '0',
subject varchar(100) NOT NULL default '',
body varchar(255) NOT NULL default '',
owner varchar(30) NOT NULL default '',
time timestamp(14) NOT NULL,
PRIMARY KEY (newsnum),
UNIQUE KEY newsnum (newsnum)
) TYPE=MyISAM;
From everything I've read, Timestamps do not need a value to be sent to them...a null value is set to the correct time. Thanks to all who help
Ogmios
