function memberlist(){ echo ('

MEMBER LIST

'); $query="SELECT * FROM users` WHERE rank='ranked' ORDER BY name1 ASC"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $name1 = htmlentities(mysql_result($result,$i,"name1")); $location = stripslashes(mysql_result($result,$i,"location")); $carmake = htmlentities(mysql_result($result,$i,"carmake")); $carmodel = htmlentities(mysql_result($result,$i,"carmodel")); $rank = htmlentities(mysql_result($result,$i,"rank")); echo('
Name:
Location:
Car Make:
Car Model:
Ranked:
'.$name1.'
'.$location.'
'.$carmake.'
'.$carmodel.'
'.$rank.'
'); echo ('

 

 
') ; $i++; } }