Sorry for the length but can some help me with this? This retrives no data at all. If you want to see the database, $databaseserver is 24.78.141.27 $databaseuser is rockey $databasepass is 1984ars and $databasename is db_noaman.
Thanks in advance for any help.
<?php
$db = mysql_connect("$databaseserver", "$databaseuser", "$databasepass");
mysql_select_db("$databasename",$db);
$sortby = "name ASC";
$sql = "SELECT * FROM $playerstable ORDER BY $sortby LIMIT $start, $finish";
$result = mysql_query($sql,$db);
$num = mysql_num_rows($result);
$cur = 1;
echo "<ol>";
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$name = $row["name"];
$mail = $row["mail"];
if ($mail == "n/a") {
$maillink = "n/a";
}
else {
$maillink = "<a href='mailto:$mail'>mail</a>";
}
$icq = $row["icq"];
if ($icq == "n/a") {
$icqlink = "n/a";
}
else {
$icqlink = "<a href='http://wwp.icq.com/scripts/Search.dll?to=$icq'>$icq</a>";
}
$aim = $row["aim"];
if ($aim == "n/a") {
$aimlink = "n/a";
}
else {
$aimlink = "<a href='aim:addbuddy?screenname=$aim'>$aim</a>";
}
$country = $row["country"];
?>
<tr>
<td width="20%" bgcolor="<?php echo"$color4" ?>" align="left" nowrap><p class='text'> <?php echo "<img src='$directory/flags/$country.bmp' align='absmiddle'> <a href='$directory/profile.php?name=$name'>$name</a>"?> <?php echo "$penplayer" ?> <font color="<?php echo "$color" ?>"><?php echo"$text" ?></font> </td>
<td width="20%" bgcolor="<?php echo"$color4" ?>" align="left" nowrap><p class="text"><?php echo "$maillink" ?></td>
<td width="20%" bgcolor="<?php echo"$color4" ?>" align="left" nowrap><p class="text"><?php echo "$icqlink" ?></td>
<td width="20%" bgcolor="<?php echo"$color4" ?>" align="left" nowrap><p class="text"><?php echo "$aimlink" ?></td>
</tr>
<?php
$cur++;
}
echo "</ol>";
?>
</table>
</center>
</div>
<center>
