[SOLVED] Query Help

[[email protected]]

I want to do a select query with like:

SELECT * FROM this,that WHERE this.a = '1' AND that.b = '0'

but when i do, this and that are mixed together in the array, overwriting eachothers row names if they are the same.

How can i fix this?

[accident]

by instead of doing * select your field names

 

so if you have 2 tables and both have a name column you would do

 

SELECT this.name as thisname, that.name as thatname ... etc

you can obviously change thisname  and thatname to be whatever you want it to be

[[email protected]]

oh ok thanks