hello folks i need something to know
<?
require_once 'config.php';
$id = $_GET['id'];
$id2 = ( $id + 1);
echo "<p>id $id";
MySQL_connect("$host","$login","$pass");
MySQL_select_db("$db") or die("Could not select database");
$sql = "SELECT id, username, surname, usermail, city, status from $table WHERE id = $id";
echo "<p>$sql";
$query = mysql_query($sql) or die(mysql_error());
#$total = mysql_num_rows($query);
function rowColor($id)
{
if($id%2) {
return "row1";
} else {
return "row2";
}
}
while ( $rows = MySQL_fetch_array($query) ) {
$id = $rows['id'];
echo "<p>$rows[0]";
$username = $rows['username'];
$usermail = $rows['usermail'];
$city = $rows['city'];
$surname = $rows['surname'];
$status = $rows['status'];
echo "<table border=0 cellPadding=0 cellSpacing=0 width=300 height=100 class=techline>";
echo "<tr>";
echo "<td class=\"".rowColor($id)."\">";
echo "<br><b>User Name:</b> $username </a>";
echo "<br><b>User Email:</b> $usermail";
echo "<br><b>User City:</b> $city </a>";
echo "<br><b>User Surname:</b> $surname";
echo "<br><b>User Status:</b> $status";
echo "</td>";
echo "</tr>";
echo "<br><b>Next</b><a href = det.php?id=$id2> $username </a>";
}
MySQL_close()
?>
I have script that list users then when i click on user i get details, this is detail script i nedd to know how i make link Next User
http://213.163.120.254/other/test/index.php
there u can test it
the link must look like this
echo "<br><b>Next</b><a href = det.php?id=$id> $username </a>";
