[SOLVED] Need Help With A Query!

[monkeybidz]

I need help creating a query to retrieve a comment from database.

 

DB TABLE NAME = MYSITE_BIDS

 

FIELD = `id`

FIELD = `comment`

 

I have a form I created to define id on my screen and I named it $comment_id

 

I tried:

query="SELECT `comment` FROM MYSITE_BIDS WHERE id='$comment_id'";

 

I was hoping to enter a comment_id on my form and get a result from mysql that matches comment_id and id.

 

Can anyone help?