WHERE var AND var

[Anon]

OK, I have to get a MySQL result to be narrowed down and I have $result=blah blah blah and all that. Actually this is what I have so far for that one thing.

$result=mysql_query("SELECT * FROM comments WHERE id=$id ORDER BY id DESC");

BUT where it says WHERE id=$id I need another one like section=$section. AND wouldnt work along with && or &. How do I do this so its somethign like this:

$result=mysql_query("SELECT * FROM tute_comments WHERE tute_id=$id AND section=$section ORDER BY id DESC");

[Anon]

the syntax (last line)looks correct to me, unless $section is a string and not an INT. if it is a string then you need single quotes around it:

$result=mysql_query("SELECT * FROM tute_comments WHERE tute_id=$id AND section='$section' ORDER BY id DESC");

Have you tried it on a command line and see what happens?

[Anon]

Yes, thank you. After I posted this, I realized that I needed the quotes.

[Anon]

$result=mysql_query("SELECT * FROM tute_comments WHERE tute_id='$id' AND section='$section' ORDER BY id DESC");

try that