Jump to content


Photo

users in members page


  • Please log in to reply
9 replies to this topic

#1 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:25 AM

im tring to make a page where the members are sorted by abc order then
beside there name it has a number and it goes in order 1 2 3 4 5 6 ... etc

heres what i have if u can make it echo a number before the username:

<?php
$getuser = mysql_query("SELECT * from users order by username");
while ($user = mysql_fetch_array($getuser))
{
echo (" <a href=\"members.php?user=$user[username]\">$user[username]</a><br />\n");
}
?>

plz help thanks

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 15 July 2006 - 07:28 AM

<?php
$getuser = mysql_query("SELECT * from users order by username");
$i = 1;
while ($user = mysql_fetch_array($getuser))
{
echo ("$i <a href=\"members.php?user=$user[username]\">$user[username]</a><br />\n");
$i++;
}
?>


#3 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:32 AM

i tried that but it didn't work b4 lol
and i know why cuz
im not that smart awake with only
5-6 hours or sleep cuz i didnt put
$i++ lol stupid me lol

#4 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 15 July 2006 - 07:33 AM

5-6 hours.... lucky you.

#5 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:34 AM

i know but im 14 lol

#6 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:35 AM

will u plz tell me how the karma works i dont get it im
usually pretty nice and isnt karma like how u think about other ppl
if so why do i have -2

#7 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:36 AM

no wonder u have 2000 + post uve been here for almost 2 years lol i just started this mourning early

#8 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 15 July 2006 - 07:40 AM

will u plz tell me how the karma works

Who cares?

#9 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 15 July 2006 - 07:48 AM

me it makes me look bad  :'( :'(

#10 pixy

pixy
  • Members
  • PipPipPip
  • Advanced Member
  • 295 posts

Posted 15 July 2006 - 04:55 PM

Lol, dude, chill out.

Later today I'll post you my view_users.php script if you want it. It lets you sort by the different types of information (IE, order by username, first name, last name, etc.) pagnates results over pages so you don't have to show a long list of members on one page.

This is a .44 Caliber Loveletter straight through my heart.

Tabulas + Threadless + Hire Me!





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users