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"; Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/178178-common-field-in-database/#findComment-939627 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.