More than 2 specifications in WHERE clause

[nzol]

I want to get data from mysql database with more than two fields matching in the WHERE clause. For example I want something like this:

SELECT * FROM users WHERE town='$town' AND age='$age' AND firstname='$firstname'");

 

Now for some reason, Mysql does not allow more than two specifications in the WHERE clause.

 

If someone could please tell me away to get around this, it would be very appreciated.

[Pikachu2000]

What would make you think MySQL doesn't allow that?

[nzol]

Because I tried the query and it said;

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ='1' AND alas='Login failed' AND ns='Page'' at line 1

 

If you know if it does please tell me!

 

Thanks

[trq]

Can we see your actual query?

[Pikachu2000]

It does work. There's got to to be something else wrong with the query. Echo the query string and paste it in here so we can get to the bottom of this . . .

 

(From the look of the error, and the way you formed the query string chunk you posted in the OP, I'm going to go out on a limb and guess that you're using a variable for the field name just prior to `alas` that is supposed to equal 1, and the variable is actually empty.)

[nzol]

@Pikachu2000:  You are absolutely correct! I accidentally put $ before the field name!

 

Thank you very much.

[Pikachu2000]

No problem. Glad it was something that simple.