Simple Member script help? - Page 2

Order · 04-14-2005

You may also have problems with the rank names, in which you would want a query like so:

SELECT * FROM members WHERE rank = 'Members'

As opposed to sticking strings together, just create three seperate queries.

ViciOuS · 04-14-2005

Yes!, it works

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Members List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
a{text-decoration:none}
//-->
</style>
<style>
a:link{color:red; text-decoration:underline; }
a:visited{color:red; text-decoration:underline; }
a:active{color:red; text-decoration:underline; }
a:hover{color:orange; text-decoration:underline; }
</style>
<link href="style.css" type="text/css" rel="stylesheet">
</head>

<BODY BGCOLOR=#332815 background="images/image_22.gif" link="#000000" vlink="#F00000" bgproperties="fixed" LEFTMARGIN=2 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr> 
    <td><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Members List</font></b></td>

  </tr>
  <tr>
    <td bgcolor="#F5F5F5">
<table align="center" width="100%" border="0">
  <tr>
    <td align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><br><br>

<u><b>Leader and Founder</b></u><br>Dahnkuana[aD]

     <br><br>

<?php
include('admincp/mysql_connect.php');

$council = "SELECT * FROM members WHERE rank='Council'";
$senior = "SELECT * FROM members WHERE rank='Senior Member'";
$member = "SELECT * FROM members WHERE rank='Member'";

$sql["Council"] = $council;
$sql["Senior Members"] = $senior;
$sql["Members"] = $member;

echo '<div style="text-align: center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">';

foreach($sql as $key => $current){

echo "<u><b>$key</b></u>";


 if($ret = mysql_query($current))
 {
   while($row = mysql_fetch_array($ret))
   {
    echo '<br />' . $row['member'];;
   }
 } else {
   die('MySQL Error: ' . mysql_error());
 } 

 echo '</p>';
}
?>

</font>
    </td>
  </tr>
</table>
    </td>
  </tr>
</table>

</body>
</html>

Thanks once again guys, you do an awesome job of teaching and explaining. I have learned a lot from BioRUST Forums

Order · 04-15-2005

you are more then welcome.. hang around to learn more.