[PHP]Users list

cipcip · 04-27-2011, 01:18 PM

A really simple php users list.

The code:

PHP Code:

  <?php

$sql = "SELECT * FROM users ORDER BY user";

$res = mysql_query($sql);

 
if (mysql_num_rows($res)){

while ($list = mysql_fetch_array($res)) {

 
$letter = strtoupper(substr($list['user'],0,1));

 
if ($letter != $prev_row) {

echo "<br /><b><u>$letter</u></b><br />";

} 

 
echo "<a href='#'>{$list['user']}</a> <br />";

????: NamePros.com http://www.namepros.com/code/712745-php-users-list.html
 
$prev_row = $letter;

}

?>

Will output this:

http://i53.tinypic.com/1zodlwz.jpg

Enjoy!

**Eric** · 04-27-2011, 01:45 PM

Instead of

PHP Code:

  $letter = strtoupper(substr($list['user'],0,1)); 

????: NamePros.com http://www.namepros.com/showthread.php?t=712745

You could also

PHP Code:

  $letter = strtoupper($list['user']{0});

04-27-2011, 01:18 PM	THREAD STARTER #1 (permalink)
cipcip NamePros Regular Join Date: Mar 2007 Location: Constanta, Romania Posts: 502	[PHP]Users list A really simple php users list. The code: PHP Code: `<?php $sql = "SELECT * FROM users ORDER BY user"; $res = mysql_query($sql); if (mysql_num_rows($res)){ while ($list = mysql_fetch_array($res)) { $letter = strtoupper(substr($list['user'],0,1)); if ($letter != $prev_row) { echo "<br /><b><u>$letter</u></b><br />"; } echo "<a href='#'>{$list['user']}</a> <br />"; ????: NamePros.com http://www.namepros.com/code/712745-php-users-list.html $prev_row = $letter; } ?>` Will output this: http://i53.tinypic.com/1zodlwz.jpg Enjoy! __________________ Social networking aggregator

04-27-2011, 01:45 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	Instead of PHP Code: `$letter = strtoupper(substr($list['user'],0,1)); ????: NamePros.com http://www.namepros.com/showthread.php?t=712745` You could also PHP Code: `$letter = strtoupper($list['user']{0});`

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Link Building Websites List - 1 to 8000 websites list with PR	neejamb	For Sale / Advertising Board	1	10-07-2010 01:13 PM
Legal/Attorney/Lawyer Link Exchange	airnike764	Link Exchange Requests	2	10-07-2010 04:52 AM
What's This Russian Saying To Me?	weblord	The Break Room	4	07-08-2006 01:45 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)