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
Code: Select all
SELECT
usernames.users.name, usernames.users.online
FROM
usernames.users,
accounts.accounts
WHERE
usernames.users.online = '1'
Thanks in advance.