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. Link to comment https://forums.phpfreaks.com/topic/147894-solved-mysql-query-problem-looped-results/ Share on other sites More sharing options...
sandstorm140 Posted March 4, 2009 Author Share Posted March 4, 2009 Figured it out using JOIN Link to comment https://forums.phpfreaks.com/topic/147894-solved-mysql-query-problem-looped-results/#findComment-776255 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". Link to comment https://forums.phpfreaks.com/topic/147894-solved-mysql-query-problem-looped-results/#findComment-776428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.