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' Code (markup): I'm fairly new to MySQL, any help/advice would be splendid. Thanks in advance.
SELECT usernames.users.name, usernames.users.online FROM usernames.users, accounts.accounts WHERE usernames.users.online = 1 // if online is numberic