guestbook problems

[aznjay]

<?
session_start();

$link = mysql_connect('localhost','chaotici_commu', 'dragon')
    or die("Could not connect");
mysql_select_db('chaotici_chaotic')
    or die("Could not select database");


$my_quadrant = $_SESSION['edithtml']; <<username
$email = $_POST['email'];
$comment = $_POST['comment'];



$update ="UPDATE users SET comment='$comment', email='$email'  WHERE username='$my_quadrant'";
mysql_query($update) or die ("Could not add data to the table");

?>

It won't insert the stuff from comments and email POST. Can anyone help me.

[leatherback]

Hi,

Place an
echo $update;
after you have defined the $update variable. This will give you the querystring which is passed to the database, and will in most cases give you a hint on WHY the query doesn't work.

J