MySQL query to fetch all user datas

[Gajeel]

Hello.

I am trying to make a user list for the come back of HabPRO. The user list will contain all user datas (username, motto, last online, and look), and their avatar will appear on the left side (like how a staff page is).

However, I am troubled on what syntax I should use in fetching them, and or if they are right (and in echoing the styling, the content boxes, the online/offline red/green color etc.).

So here is the page without the actual userlist:

Immediate help would be great.

 

[iHarrison]

I maybe wrong, but try something like this:

$result = mysql_query("SELECT * FROM users");
 
while($row = mysql_fetch_assoc($result)) {
   echo $row['username'];
   echo $row['motto'];
   echo $row['last_online'];
   echo $row['figure'];
}

That maybe wrong tho and you'll need to do some editing for it to show the figure and last_online correctly. But it should be something to start with.

 

[Gajeel]

Thanks for the help. I'd go and refer styling on how the staff page echoes the style. TY so much. But if I get in trouble can I pm you?

 

[iHarrison]

Thanks for the help. I'd go and refer styling on how the staff page echoes the style. TY so much. But if I get in trouble can I pm you?

Sure

 

[Muffins]

How would we make it run onto a second page when the amount of members gets over 10?

 

[iHarrison]

How would we make it run onto a second page when the amount of members gets over 10?

You could limit how many appear in a query I suppose =P

 

[Muffins]

I know that but then it would only show the amount in the limit. Wait I think I have an idea. I can use num_rows and divide that number by 10 and then make the amount of links counting from 1 to (result of the num_rows divided by 10 and rounded) and make the links use a $_GET request to get page 2 etc...

 

[Gajeel]

You must be registered for see links

is a pro. He is doing it for me.