Fabbuccino Posted October 19, 2009 Share Posted October 19, 2009 I have two tables, both having one common field, along with other uncommon fields, of course. the tables look similar to members ======================= id | username | password, etc ======================= comments ======================= id | comment | memberid, etc ======================= what my issue is that when I perform my query and join both tables making memberid = members.id, if i want to print/echo out the comments id i can't. I tried using a fetch array and performing a $row['id'] ..it gives out the id from the members page. i tried $row['comments.id'] and it didn't print anything. how can i specify that I want the id from the comments page? EDIT: nevermind. I got it. I just switched the tables around in the query putting my comments table second $sql = "SELECT * FROM members, comments WHERE members.id=comments.memberid"; Link to comment https://forums.phpfreaks.com/topic/178178-common-field-in-database/ Share on other sites More sharing options...
fenway Posted October 19, 2009 Share Posted October 19, 2009 I would recommend proper JOIN syntax... it will serve you well in the long run. Link to comment https://forums.phpfreaks.com/topic/178178-common-field-in-database/#findComment-939627 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.