Simple Mysql horizontal list problem
Posted: Mon Feb 01, 2010 9:18 am
Hello again, members of the php Technorati. I bring another one of my problems to your door step and humbly ask for your guidance. How do I get Mysql to list all ids horizontally and vertically. The code I have lists vertically, but repeats the same id horizontally. Here is the code:
Please enlighten me. As always , Thanks in advance,
Batoe
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