Limit echo requests

cheaper

Hi All

I wonder if anyone can help?

On our main site page we have the top holiday deals taken from our varios holiday sections if you go to www.cheaperholidays.com you will see what i mean, the coding is as below,

<td class="vertdots"><img src="images/1x1.gif" width="1" height="1" alt="Superb travel deals" border="0" /></td>
<td width="232" height="170" style="padding-top:2px; padding-left:8px; padding-right:8px">

<img src="images/header_med.gif" width="178" height="29" alt="Mediterranean Holidays, The Prices are inclusive no hidden extras" border="0" /><br />
<table width="232" cellpadding="0" cellspacing="0" border="0" style="margin-top:10px">
<?php
$sql_qs = "SELECT datefrom, fromairport, Left(toairport, 10), adultprice FROM quickdeals where hol_section = 'Mediterranean' ORDER BY adultprice limit 10";
$db0->setsql($sql_qs);
$db0->selectquery();
for ($i=0; $i < $db0->getnumberrows(); $i++)
{
$listdest=$db0->result[$i];
echo "<td><a href='med.php' class='small'>$listdest[0]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'>$listdest[1]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'>$listdest[2]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'>$listdest[toairport]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'><b>$listdest[3]</a></td>";
echo "<td align='right' style='padding-left:2px'><a href='med.php'><img src='images/arrow_blue.gif' width='8' height='8' alt='Lastminute to the Mediterranean' border='0' vspace='5' /></a></td>";
echo "</tr>";
}
?>
<tr>
<td colspan="5" style="padding-top:8px" align="right"><a href="Spain-Cyprus-Malta-Tunisia-Greece-holidays.php"><img src="images/btn_viewall.gif" width="62" height="14" alt=" View All holidays, Please note call us for the latest deals, Holidays or flights are inclusive no hidden extras or booking fees " border="0" /></a></td>
</tr>
</table>

is there a simpler we can get the data..

The reason i ask is the yahoo thinks we have to many internal links...

Kind regards
Kevin
www.cheaperholidays.com

sidney

if you dont want all the links remove the <a href""> and </a>

from the values you dont require as links

ednark

you might benefit from the heredoc syntax to print multiple lines with variables mixed in

this is what you had

for ($i=0; $i < $db0->getnumberrows(); $i++)
{
$listdest=$db0->result[$i];
echo "<td><a href='med.php' class='small'>$listdest[0]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'>$listdest[1]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'>$listdest[2]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'>$listdest[toairport]</a></td>";
echo "<td style='padding-left:4px'><a href='med.php' class='small'><b>$listdest[3]</a></td>";
echo "<td align='right' style='padding-left:2px'><a href='med.php'><img src='images/arrow_blue.gif' width='8' height='8' alt='Lastminute to the Mediterranean' border='0' vspace='5' /></a></td>";
echo "</tr>";
}

this is what is could look line...

for ($i=0; $i < $db0->getnumberrows(); $i++) 
{ 
$listdest=$db0->result[$i]; 
print <<<ENDLIST
<td><a href='med.php' class='small'>{$listdest[0]}</a></td>"; 
<td style='padding-left:4px'><a href='med.php' class='small'>{$listdest[1]}</a></td>
<td style='padding-left:4px'><a href='med.php' class='small'>{$listdest[2]}</a></td>
<td style='padding-left:4px'><a href='med.php' class='small'>{$listdest['toairport']}</a></td>
<td style='padding-left:4px'><a href='med.php' class='small'><b>{$listdest[3]}</a></td>
<td align='right' style='padding-left:2px'><a href='med.php'><img src='images/arrow_blue.gif' width='8' height='8' alt='Lastminute to the Mediterranean' border='0' vspace='5' /></a></td>
</tr>
ENDLIST;
}

it will minimize calls to echo(), but to be safe and clear wrap all your variables in {}