More than one AND in mysql statement?

[webnewone]

Can someone tell me how to do this?

I want a select statement that selects based on three conditions not just two so instead of

$sql= "SELECT * FROM table_name 
                    WHERE field1='$field_value1' AND field2='$field_value2' ";

I need something like

$sql = "SELECT * FROM table_name
                     WHERE field1='$field_value1' AND field2='$field_value2' AND field3='$field_value3' ";

Any idea how this can be done - doing it as shown above doesn't work. It'll work if I only have it based on 2 conditions but not for 3. Any work-around ideas would be greatly appreciated!

😃

[yelvington]

If you're having problems with this, it's not because of having too many ANDs. Use as many as you want.

Echo your SQL query and examine it to make sure you didn't trip on something else.

[webnewone]

Thanks for the tip!

You were absolutely right - I was using the wrong field name. Thanks for your kind reply 🙂