So i have a members list,
http://sketchedneo.com/testmemberlist.php
I want to make the names clickable so people can view the members profiles.
But Ive gone around in cirlces for 3 days now.
Can someone help please.
[php]<?php
$pagetitle = “All Users”;
$checkrank = 5;
include ($_SERVER[‘DOCUMENT_ROOT’].’/header.inc.php’);
$min=$_GET[‘min’];
$num = mysql_num_rows(mysql_query(“SELECT id FROM members”));
echo "Lutari has $num members.
<table width=“226” border=“0” cellspacing=“0” cellpadding=“4” style="border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; ">
if ($num <= 0)
{
echo "
if (!$min) { $min = 0; }
$max = $min + 50;
$sort = mysql_query(“SELECT * FROM members ORDER BY username LIMIT $min,50”);
while($sort2 = mysql_fetch_array($sort))
{
if (!$min) { $min = 0; }
$max = $min + 50;
{
$x = 0;
if ($num >= 1)
$datejoin = date(“M j Y”,$sort2[joined]);
$rankk = mysql_fetch_array(mysql_query(“SELECT * FROM jobs WHERE id = ‘$sort2[rank]’”));
echo “\n”;
if($sort2[id]){
echo("
"); }
}
}
echo "
";
if ($num >= 50)
{
echo “
<a href=$baseurl/staff/all_members.php?min=$max>Next page
”;}
if ($min != 0)
{
$prev_min = $min - 50;
echo “
<a href=$baseurl/staff/all_members.php?min=$prev_min>Previous page
”;}
$x = 0;
echo “
\n”;
echo “\n”;
include ($_SERVER[‘DOCUMENT_ROOT’].’/footer.inc.php’);
?>[/php]
I also want to code it onto my forum to make their names click to their profiles too.
http://www.sketchedneo.com//forum/forum.php
[php]<?php
$pagetitle = “Forum”;
$checkrank = 2;
include ($_SERVER[‘DOCUMENT_ROOT’].’/header.inc.php’);
include ($_SERVER[‘DOCUMENT_ROOT’].’/security/smiliesonly.php’);
$min=$_GET[‘min’];
$id=$_GET[‘id’];
$sort00 = mysql_fetch_array(mysql_query(“SELECT * FROM forum_boards WHERE id = ‘$id’”));
$file = “staff”;
if ($sort00[filed] == $file AND $rank < 5)
{
die(“You can not view this board.”);
}
$num = mysql_num_rows(mysql_query(“SELECT id FROM forum_topic WHERE board = ‘$id’”));
echo “<a href=”$baseurl/forum/forum.php">Boards || <a href="$baseurl/forum/add_topic.php">Add Topic || <a href="$baseurl/forum/preferences.php">Preferences
";
echo "<table width=“635” border=“0” cellspacing=“0” cellpadding=“4” style="border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; ">
if ($num <= 0)
{
echo "
if (!$min) { $min = 0; }
$max = $min + 30;
$sort = mysql_query(“SELECT * FROM forum_topic WHERE board = ‘$id’ ORDER BY updated DESC LIMIT $min,30”);
while($sort2 = mysql_fetch_array($sort))
{
if (!$min) { $min = 0; }
$max = $min + 30;
{
$x = 0;
if ($num >= 1)
echo “\n”;
if($sort2[id])
{
$numreplies = mysql_num_rows(mysql_query(“SELECT * FROM forum_replies WHERE topic = ‘$sort2[id]’”));
$sort4 = mysql_fetch_array(mysql_query(“SELECT * FROM forum_replies WHERE topic = ‘$sort2[id]’”));
$ftime = date(“H:i”,$sort2[date]);
$fdate = date(“M j Y”,$sort2[date]);
$updated = date(“M j Y”,$sort2[updated]);
$ftitle = smiliesonly($sort2[title]);
echo("
<tr>
<td width=\"108\" valign=\"middle\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\"><center>
<p>$sort2[postedby]<br>
$fdate $ftime</p>
</center></td>
<td width=\"424\" valign=\"middle\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#f4f4f4;\"><a href=\"$baseurl/forum/topic.php?id=$sort2[id]\">$ftitle</a></td>
<td width=\"77\" valign=\"middle\" style=\"border-bottom: 1pt solid black; background-color:#f4f4f4;\"><center>
$updated<br>
Replies: $numreplies
</center></td>
"); }
}
}
echo "
";
if ($num >= 30)
{
echo “
<a href=$baseurl/forum/board.php?min=$max>Next page
”;}
if ($min != 0)
{
$prev_min = $min - 30;
echo “
<a href=$baseurl/forum/board.php?min=$prev_min>Previous page
”;}
$x = 0;
echo “
\n”;
echo “\n”;
include ($_SERVER[‘DOCUMENT_ROOT’].’/footer.inc.php’);
?>[/php]
Thank you