'DELETE FROM question

[BIOSTALL]

hey, i'm using this query:

DELETE FROM Forum_Replies WHERE reply_message='$mesage', thread_id='$tid', reply_postdate='$pdate', reply_posttime='$ptime'

At first it didnt work so i used mysql_error() and i got this:

You have an error in your SQL syntax near '??, thread_id=37, reply_postdate=2005-06-20, reply_posttime=23:24:27' at line 1

The bit where it says '?? is the last part of $mesage and if i select another row to delete then it returns the last part of the newly selected $mesage. I cant figure out why its giving me an error, the variables are obviously being assigned ok as they are being returned in the error so it must be my query and the actual deletion process :-S Anyone help please??

Thanks, BIOSTALL

[halojoy]

reply_message='$mesage'
Are you sure it should be '$mesage' with only one 's'

[leatherback]

Hi,

In the query, replace the , by AND, and I think you shoul dbe fine

J

[BIOSTALL]

Thanks LeatherBack :-D