newbie question: my script doesn't work
Posted: Wed Dec 24, 2003 5:43 am
This is the code that "should" send my guestbook-data to my DB.
When i push the submit button everything goes normal (message succesfully entered), the data does not get inserted... (sorry for my bad english)
(i CAN on the otherhand, read data out of the DB, (data i inserted using mySQL Control center))
When i push the submit button everything goes normal (message succesfully entered), the data does not get inserted... (sorry for my bad english)
(i CAN on the otherhand, read data out of the DB, (data i inserted using mySQL Control center))
Code: Select all
<?php
//prepare variables:
$name = $_GET["name"];
$email = $_GET["email"];
$datetime = date("Y.m.d g:i:s");
$message = $_GET["message"];
//send to DB
$db = mysql_connect($dbhost,$dbuser); //DB link_identifier
mysql_select_db($mydb,$db); //Select DB
$query = "INSERT INTO guestbook(id, name, email, datetime, message VALUES(, '$name', '$email', '$datetime', '$message')";
$result = mysql_query($query);
echo "Message successfully entered";
?>