[PHP] Please help with code

[Denis L. Menezes]

Hello friends,

can someone tell me what is wrong with this code :


<form name="form1" method="post" action="">
  <p>
    <input type="text" name="newsid">
  </p>
  <p> 
    <input type="text" name="title">
  </p>
  <p> 
    <input type="text" name="author">
  </p>
  <p>
    <input type="text" name="body">
  </p>
  <p> 
    <input type="submit" name="Submit" value="Submit">
  </p>
  </form>
</body>
<?php
$link=mysql_connect("localhost","myid","mypassword");
if ($link){
print "link id is $link";
} else {
print "error connecting to database";
}
$posted=time();
$query="INSERT INTO news (newsid,title, author, body, posted)
         VALUES($newsid,$title, $author, $body, UNIX_TIMESTAMP())";
IF (mysql_query($query)){
  print "Row added to table";
  } else {
  print "error adding row";
  }
?>


It gives the link ID. But then gives "error adding row"

Thanks in advance

Denis


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