Code Help!

[Brad]

how would i get this to show Only Online Rank 4

GetRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 4 ORDER BY  name DESC");
                            while($Ranks = mysql_fetch_assoc($GetRanks))

 

[Markshall]

You'd have to do a query to get all the online users, loop through them and find their rank and if it matches 4, do your shit.

 

[Brad]

You'd have to do a query to get all the online users, loop through them and find their rank and if it matches 4, do your shit.

Ill Try

 

[IntactDev]

$getRanks = mysql_query("SELECT * FROM users WHERE rank = 4 AND online = 1 ORDER BY username DESC");

That should work, if I remember anything about Habbo. That query should return all users that are online, that is rank 4.

EDIT: Oops. I know what I did wrong.

 

[Brad]

Nope just shows the exac same

 

[IntactDev]

I updated the post ^

 

[Brad]

Nope just Looks Like this

You must be registered for see links

i think it due to not getting any users.

 

[IntactDev]

Nope just Looks Like this

You must be registered for see links

i think it due to not getting any users.

What's the field that has the online value? is it "online"?

 

[Brad]

What's the field that has the online value? is it "online"?

yes

 

[IntactDev]

$getRanks = mysql_query("SELECT * FROM users WHERE rank = '4' AND online = '1' ORDER BY username DESC");

 

[Brad]

$getRanks = mysql_query("SELECT * FROM users WHERE rank = '4' AND online = '1' ORDER BY username DESC");

Still Same Ahh

 

[Find]

Still Same Ahh

paste the whole page

 

[St4nley]

Its the same because that code isnt displaying shit its just running you need to make a container that will echo that code -.-

 

[Markshall]

I assume your users and online users are separate tables, if so, you'll have to do what I suggest. Not sure whether the SQL JOIN() command could help you. Look into it.

 

[Brad]

I assume your users and online users are separate tables, if so, you'll have to do what I suggest. Not sure whether the SQL JOIN() command could help you. Look into it.

Ahh Thanks anyway ill take a look into that now

 

[Find]

Just waste the whole page