Forum Moderators: coopster
<?php
session_start();
?>
<html>
<HEAD>
<TITLE>MEMBER LIST</TITLE>
<link href="../css/red.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY class="body">
<h5 align="center">Members List</h5>
<table class="body" border="1" bgcolor="#CCCCCC" bordercolor="#000000" align="center">
<tr bgcolor="#FF0000">
<td><font color="#000000"><b>Username</b></font></td>
<td><font color="#000000"><b>Status</b></font></td>
<td><font color="#000000"><b>Gender</b></font></td>
<td><font color="#000000"><b>Website</b></font></td>
<td><font color="#000000"><b>More Info</b></font></td>
</tr>
<?php
include("db_fns.php"); // file to connect to DB
$result = "SELECT `ID` FROM members";
$ms_query = mysql_query($result, $db_conn) or die (mysql_errno().": ".mysql_error()."<BR>");
$count = mysql_num_rows($ms_query);
$id_num = 0;
for ($id_num > 0; $id_num >= $count; $id_num++)
{
$user_var = "SELECT * FROM members WHERE ID = '$id_num'";
$user_var_query = mysql_query($user_var, $db_conn) or die (mysql_errno().": ".mysql_error()."<BR>");
while($row = mysql_fetch_array($user_var_query)) {
$user_name = $row['name'];
$user_email = $row['email'];
$user_bio = $row['bio'];
$user_aim = $row['aim'];
$user_gender = $row['gender'];
$user_website = $row['website'];
$user_bday = $row['birthdate'];
$user_status = $row['status'];
if($user_status == "")
{
$user_status = "Member";
} else {
$user_status = $row['status'];
}
}
print"<tr>
<td>$user_name</td>
<td>$$user_status</td>
<td>$user_gender</td>
<td>$user_website</td>
<td>More Info</td>
</tr>"; // row printed with member info
}
?>
</table>
</body>
</html>
It looks to me like your making it a little harder on yourself then you need to be. I am tired so I may be reading it wrong. But why not restructor it more like this:
$result = "SELECT * FROM members";
Left out stuff here!
while($row = mysql_fetch_array($user_var_query))
{
<tr>
<td>$row['name']</td>
<td>$row['status']</td>
<td>$row['gender']</td>
<td>$row['website']</td>
</tr>
}
There may be some major issues with this code... which I think there are it just doesnt seem quite right either but its a start. If I remember Ill look at it again in the morning after I have rested some.
<?php
session_start();
?>
<html>
<HEAD>
<TITLE>MEMBER LIST</TITLE>
<link href="../css/red.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY class="body">
<h5 align="center">Members List</h5>
<table class="body" border="1" bgcolor="#CCCCCC" bordercolor="#000000" align="center">
<tr bgcolor="#FF0000">
<td><font color="#000000"><b>Username</b></font></td>
<td><font color="#000000"><b>Status</b></font></td>
<td><font color="#000000"><b>Gender</b></font></td>
<td><font color="#000000"><b>Website</b></font></td>
<td><font color="#000000"><b>More Info</b></font></td>
</tr>
<?php
include("db_fns.php"); // file to connect to DB
$user_var = "SELECT * FROM members";
$user_var_query = mysql_query($user_var, $db_conn) or die (mysql_errno().": ".mysql_error()."<BR>");
while($row = mysql_fetch_array($user_var_query)) {
$user_name = $row['name'];
$user_email = $row['email'];
$user_bio = $row['bio'];
$user_aim = $row['aim'];
$user_gender = $row['gender'];
$user_website = $row['website'];
$user_bday = $row['birthdate'];
$user_status = $row['status'];
if($user_status == "")
{
$user_status = "Member";
} else {
$user_status = $row['status'];
}
print"<tr>
<td>$user_name</td>
<td>$user_status</td>
<td>$user_gender</td>
<td>$user_website</td>
<td>More Info</td>
</tr>";
}
?>
</table>
</body>
</html>
Yeah what I put up there is kind of nasty I didnt think it looked right last night but couldnt put my finger on it.
