Technology, Support, and News Forum

[stuartj Profile]

Anyone know why this SQL query doesnt work?

SELECT * FROM enquirys WHERE action='1' AND WHERE record_type='1' ORDER BY id_number DESC

Thanks

Stuart

[tdcrone Profile Website]

You should be able to concatenate "where"s with an AND, not AND WHERE. I think it will work then, unless I'm missing something else.

Good luck,
-TC

[ZeroByte Profile]

The second WHERE clause is not necessary in this query.

use this instead

Code: Select all

SELECT * FROM enquirys WHERE action='1' AND record_type='1' ORDER BY id_number DESC