display two ads from mysql in left and right

[vinpkl]

hi all

i want to display two offer ads images in my php page. i am able to fetch data from mysql in my page. But the trouble is the script below displays the data in rows like one ad image above and second ad image below.
i want to display one ad in left and second ad in its right. how is it possible.

vineet

<?php
$qry="select * from special_offers order by offer_id";
$result = mysql_query($qry);
if(mysql_num_rows($result)>0)
{
while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=top>". "<img height=200 width=253 src='admin/uploads/" . $row['offer_image'] . "'/>" . "</td>";
echo "</tr>";
}
}

?>

[Kudose]

Probably because with each iteration you are making a new table row.

[rdmustang]

<?php
$qry="select * from special_offers order by offer_id";
$result = mysql_query($qry);
if(mysql_num_rows($result)>0)
{
while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=top>". "<img height=200 width=253 src='admin/uploads/" . $row['offer_image'] . "'/>" . "</td>";
if ($row=mysql_fetch_array($result)){
echo "<td valign=top>". "<img height=200 width=253 src='admin/uploads/" . $row['offer_image'] . "'/>" . "</td>";
}
echo "</tr>";
}
}

?>

[Kudose]

<?php
  $query = mysql_query('SELECT offer_image FROM special_offers ORDER BY offer_id LIMIT 0, 2') or die('Query error');
  while(($rows[] = mysql_fetch_array($query) !== FALSE)){ }
  echo '<tr>';
  if(!empty($rows[0]['offer_image']))
    echo '<td><img height=200 width=253 src="admin/uploads/'.$rows[0]['offer_image'].'" /></td>';
  echo '<td>Hello</td>';
  if(!empty($rows[1]['offer_image']))
    echo '<td><img height=200 width=253 src="admin/uploads/'.$rows[1]['offer_image'].'" /></td>';
  echo '</tr>';