sandstorm140 Posted March 4, 2009 Share Posted March 4, 2009 Hello, I'm using the following code. I'm wanting to display usernames from database: usernames table: users from field: online where online = 1. As you can see, i also have FROM accounts.accounts because later on I will need to pull information from that database simultaneously. Database: accounts table: accounts --Also has a field named "online". My problem is I should have 4 results equal to usernames.users.online=1. I get the correct 4 names, however, it seems to be looped over and over again hundreds of times. For example: username1 username2 username3 username4 //starts again.. username1 username2 username3 username4 ...etc SELECT usernames.users.name, usernames.users.online FROM usernames.users, accounts.accounts WHERE usernames.users.online = '1' I'm fairly new to MySQL, any help/advice would be splendid. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
sandstorm140 Posted March 4, 2009 Author Share Posted March 4, 2009 Figured it out using JOIN Quote Link to comment Share on other sites More sharing options...
fenway Posted March 4, 2009 Share Posted March 4, 2009 Figured it out using JOIN Then please post the solution as mark the topic "solved". Quote Link to comment 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.