Dynamic search (where 1=1)

thinker08

HI

is there a better way to do a dynamic search than using where 1=1?

Ive used where 1=1 in the past with access databases but never with my sql and i dont seem to be able to get it to work with mysql as it just returns all the values from the datbase.

the selct bit im using is

[CODE]MM_rsCars_Source="SELECT * FROM cars WHERE (1=1) AND Active = 1"[/CODE]

Im then filtering the makes table on the makeID passed through but it keeps displaying all the makes.

Thanks
Thinker08