Code: Select all
$query = "SELECT agentID FROM agent_login LIMIT 0, 200 ";
$result = mysql_query($query) or die(mysql_error());
$check = '0';
while($row = mysql_fetch_assoc($result))
{
if ($check % 2 == 0)
{
$text1 .= '<tr width="800" bgcolor=#FCE6A0 class="style1" align=center>';
}
else
{
$text1 .= '<tr bgcolor=#FCE6A0 class="style1" align=center>';
}
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '<td width="100" height="24" align="left" valign="middle" style="padding-left: 15px;"><span class="style1"><a href=http://www.resu-pic.com/get_agent.php?id='.$row['agentID'].'>'.$row['agentID'].'</a></span></td>';
$text1 .= '</tr>';
$check ++;
}
if($check == 0)
{
$text1 .= '<tr width = "800">';
$text1 .= '<td align="center" width="100%"><span class="style1"><b>No Agents found!</b></span></td>';
$text1 .= '</tr>';
}
echo $text1;Batoe