Creating a Memberlist

Robyn · 07-10-2005

I have taken the tutorial provided on the biorust design website to create a member area on my site, and it worked out fine, but I'd like to have a little more. I would like for my members to be able to search other members in a memberlist and to see their profile later on. I'd like it so that once the account is Activated, the member gets added to the memberlist. I've got this code for it, but it doesn't want to work: the problem is, that even though there's a member whose name starts with A (or B, C,...) it keeps saying there aren't any members whose name starts with A (or b, c). Did that make sence?

Anyway, here's the code I used:

Code:

<?php 

include 'config.php';

// For global registers off 
// ==================== 

$a = mysql_escape_string(trim($_GET['a'])); 

if (empty($a))    { $a = 'a';    } 

// display alphabets from A to Z for visitors to sort the list. 
?><p align="center"><a href="memberlist.php?a=1">1</a> | <a href="memberlist.php?a=2">2</a> | <a href="memberlist.php?a=3">3</a> 
| <a href="memberlist.php?a=4">4</a> | <a href="memberlist.php?a=5">5</a>
 | <a href="memberlist.php?a=6">6</a> | <a href="memberlist.php?a=7">7</a> | <a href="memberlist.php?a=8">8</a> | <a href="memberlist.php?a=9">9</a> 
| <a href="memberlist.php?a=0">0</a><br>
<a href="memberlist.php?a=A">A</a> | <a href="memberlist.php?a=B">B</a> 
| <a href="memberlist.php?a=C">C</a> | <a href="memberlist.php?a=D">D</a> | <a href="memberlist.php?a=e">E</a> | <a href="memberlist.php?a=F">F</a> 
| <a href="memberlist.php?a=G">G</a>  | <a href="memberlist.php?a=H">H</a>
 | <a href="memberlist.php?a=I">I</a> | <a href="memberlist.php?a=J">J</a> | <a href="memberlist.php?a=K">K</a> | <a href="memberlist.php?a=L">L</a>
 | <a href="memberlist.php?a=M">M</a><br>
 <a href="memberlist.php?a=N">N</a> | <a href="memberlist.php?a=O">O</a>
 | <a href="memberlist.php?a=P">P</a> | <a href="memberlist.php?a=Q">Q</a> | <a href="memberlist.php?a=R">R</a> | <a href="memberlist.php?a=S">S</a>
 | <a href="memberlist.php?a=T">T</a> | <a href="memberlist.php?a=U">U</a> | <a href="memberlist.php?a=V">V</a> | <a href="memberlist.php?a=W">W</a> 
| <a href="memberlist.php?a=X">X</a> | <a href="memberlist.php?a=Y">Y</a> 
| <a href="memberlist.php?a=Z">Z</a> 
</p>


<?php 

// get list of members 
$query = "select Username, id from Users where Activated='1' and name like '$a%' order by name "; 
$result = mysql_query($query) or die(mysql_error()); 

if (mysql_num_rows($result) !=0) 
{ 
    echo '<ol>'; 
    while($row = mysql_fetch_array($result)) 
    { 
        extract($row); 
        echo '<li><a href="viewprofile.php?id='.$id.'">'.$name.'</a></li>'; 
    } #while 
    echo '</ol>'; 
} 
else 
{ 
    echo '<p>No member names starting with '.$a.'</p>'; 
} 
?>

^^So, what's wrong with it?

scrowler · 07-11-2005

perhaps:

Code:

$query = "select Username, id from Users where Activated='1' and name like '$a%' order by name ";

should be:

Code:

$query = "select Username, id from Users where Activated='1' and name like '$a%' order by Name ASC";

what happens when you run it?

Robyn · 07-11-2005

Okay now it displays a number. Like you have a member starting with M, it displays the number 1, instead of the Member's name...

scrowler · 07-11-2005

try using this php code instead:

Code:

<?php 

// get list of members 
$query = "SELECT Username, id, Name FROM Users WHERE Activated='1' AND Name LIKE '$a%' ORDER BY Name ASC"; 
$result = mysql_query($query) or die(mysql_error()); 

if (mysql_num_rows($result) !=0) 
{ 
    echo '<ol>'; 
    while($row = mysql_fetch_assoc($result)) 
    { 
        echo '<li><a href="viewprofile.php?id='.$row["id"].'">'.$row["Name"].'</a></li>'; 
    } #while 
    echo '</ol>'; 
} 
else 
{ 
    echo '<p>No member names starting with '.$a.'</p>'; 
} 
?>

Robyn · 07-12-2005

Now that worked. Thank you.

scrowler · 07-14-2005

no problem, i hope you stick around at biorust