[email protected] Posted July 23, 2008 Share Posted July 23, 2008 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? Link to comment https://forums.phpfreaks.com/topic/116258-solved-query-help/ Share on other sites More sharing options...
accident Posted July 23, 2008 Share Posted July 23, 2008 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 Link to comment https://forums.phpfreaks.com/topic/116258-solved-query-help/#findComment-597802 Share on other sites More sharing options...
[email protected] Posted July 23, 2008 Author Share Posted July 23, 2008 oh ok thanks Link to comment https://forums.phpfreaks.com/topic/116258-solved-query-help/#findComment-597844 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.