besides the 2 semicolons you are missing that red pointed out, you're missing an echo tag for $row['clan'].
you also have a 'do{' command for no reason. along with the other changes, just take that line out and you should be good to go.
PHP Code:
<?php require_once('Connections/linblood.php');
$maxRows_list = 10;
$pageNum_list = 0;
if (isset($_GET['pageNum_list'])) {
$pageNum_list = $_GET['pageNum_list'];
}
$startRow_list = $pageNum_list * $maxRows_list;
mysql_select_db($database_linblood, $linblood);
$query_list = "SELECT clan, `character`, timezone, avail, email, msn FROM members ORDER BY clan DESC";
$query_limit_list = sprintf("%s LIMIT %d, %d", $query_list, $startRow_list, $maxRows_list);
$list = mysql_query($query_limit_list, $linblood) or die(mysql_error());
$row_list = mysql_fetch_assoc($list);
if (isset($_GET['totalRows_list'])) {
$totalRows_list = $_GET['totalRows_list'];
} else {
$all_list = mysql_query($query_list);
$totalRows_list = mysql_num_rows($all_list);
}
$totalPages_list = ceil($totalRows_list/$maxRows_list)-1;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
$num=20;
// Open the HTML table before the loop
echo '<table width="667" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutDefaultTable-->
<tr>
<td width="667" height="19" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="118" height="19" valign="top">clan</td>
<td width="130" valign="top">character</td>
<td width="69" valign="top">time zone </td>
<td width="67" valign="top">availability</td>
<td width="142" valign="top">email</td>
<td width="141" valign="top">msn</td>
</tr>
</table></td>
</tr>';
for($i=0;$i<$num;$i++){
if($i % 2 ==0)
{
$bgcolor='#f3f3f3';
}
else
{
$bgcolor='#e3e3e3';
}
echo '<tr bgcolor=$bgcolor>
<td height="19" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>'; ?>
<td width="118" height="19" valign="top" ><?php echo $row_list['clan']; ?></td>
<td width="128" valign="top"><?php echo $row_list['character']; ?></td>
<td width="71" valign="top"><?php echo $row_list['timezone']; ?></td>
<td width="67" valign="top"><?php echo $row_list['avail']; ?></td>
<td width="141" valign="top"><?php echo $row_list['email']; ?></td>
<td width="142" valign="top"><?php echo $row_list['msn']; ?></td>
<?php echo '</table></td>
</tr>
<tr>
<td height="25"> </td>
</tr>
</table>';
} // line 82
?>