help with SQL query

[unsider]

My DB has these 4 feilds:

'id', 'username', 'commenttext', 'commentdate'

 

The username = the current $session->username

The commenttext = the $_POST['commenttext']

The commentdate = NOW()

 

My form action, etc.. is all working properly, I just need to fix this query that inputs the info in the DB and I'm set.

 

Thanks.

 

<?php

// HELP FROM HERE

if(isset($_POST['commenttext'])) {

$commenttext = $_POST['commenttext'];
$username = $session->$username;

$sql="INSERT INTO comments VALUES ('$username','$commenttext', 'NOW()')";

// TO HERE

if (!@mysql_query($sql)) {
		echo 'Error adding query: ' . mysql_error();

header('main.php');

}
}
?>

[btherl]

$session->username instead of $session->$username ?

 

It's a good idea to print out $sql too, so you can see what query you are running.  That fixes a LOT of errors.

[unsider]

$session->username instead of $session->$username ?

 

It's a good idea to print out $sql too, so you can see what query you are running.  That fixes a LOT of errors.

 

Ooops, wow, well I tested it without the $ on username. Not sure how it got in there, although I think I tried a new method before resorting to questions.

 

I think my query just needs some effective rewriting.

[unsider]

I'm going to bed, but if anyone wants to help me out, I'd really apreciate it.

 

G'nite all.

[btherl]

Show us the output of "echo $sql;" and we may be able to help

[l0ve2hat3]

try this

 

 

$sql="INSERT INTO `comments` (username, commenttext, commentdate)  VALUES ( '$username','$commenttext', 'NOW()' )";