Help with Id=View


#1

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; ">

Username Joined Rank ";

if ($num <= 0)
{
echo "

There are no muted users :D "; }

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("

$sort2[username] $datejoin $rankk[job]

"); }

}

}

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; ">

Posted By Title Last Post ";

if ($num <= 0)
{
echo "

There are no topics on this board :( "; }

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


#2

Also, The warnings you get at the top of pages, are not there when logged in.