Hi all,
How can i stop this part of the code:
<TABLE cellPadding=2 cellSpacing=0 width=480>
<TBODY>
<TR>
<TD align=left vAlign=center width=\"29\">
</TD>
<TD align=left vAlign=center width=\"306\">See <a href="all.php?id=<? echo $id?>">All</a>
| <a href="us.php?id=<? echo $id?>">US</a> | <a href="aus.php?id=<? echo $id?>">Australasia</a></TD>
<TD align=left vAlign=center width=\"100\"> </TD>
</TR></TABLE><BR>
...reapeating along with the results. I want it to display only once depending the condition.
Any ideas?
Cheers,
micmac
Here is the script:
<?
$row = mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM cat1 WHERE CatParent = $id"));
if($row[0] > 0){
$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id AND active='yes' AND country IN('', 'Global', 'UK') ORDER BY pref,CatName");
while($row = mysql_fetch_array($result)){
if ( $row['description'] == "") {
?>
<TABLE cellPadding=2 cellSpacing=0 width=480>
<TBODY>
<TR>
<TD align=left vAlign=center width=\"29\">
</TD>
<TD align=left vAlign=center width=\"306\">See <a href="all.php?id=<? echo $id?>">All</a>
| <a href="us.php?id=<? echo $id?>">US</a> | <a href="aus.php?id=<? echo $id?>">Australasia</a></TD>
<TD align=left vAlign=center width=\"100\"> </TD>
</TR></TABLE><BR>
<?
echo "<TABLE><TR>";
echo "<TD align=left vAlign=center width=\"29\"><a href=\"uk.php?id={$row['CatID']}\"><IMG align=center alt=\"LET'S GO MELBOURNE\" border=0 src=\"images/uk_flag.gif\"></A>";
echo "</TD>";
echo "<TD align=left vAlign=center width=\"306\"><a href=\"uk.php?id={$row['CatID']}\">{$row['CatName']}</a></TD>";
echo "<TD align=left vAlign=center width=\"100\">< Click to view</TD>";
echo "</TR>";
} else {
?>
<TABLE cellPadding=2 cellSpacing=0 width=480>
<TBODY>
<TR>
<TD align=left vAlign=center width=\"29\">
</TD>
<TD align=left vAlign=center width=\"306\">See <a href="all.php?id=<? echo $id?>">All</a>
| <a href="us.php?id=<? echo $id?>">US</a> | <a href="aus.php?id=<? echo $id?>">Australasia</a></TD>
<TD align=left vAlign=center width=\"100\"> </TD>
</TR></TABLE><BR>
<?
echo "<TABLE cellPadding=2 cellSpacing=0 width=480>";
echo "<TBODY><TR>";
echo "<TD align=left vAlign=center width=\"29\"><a href=\"uk.php?id={$row['CatID']}\"><IMG align=center alt=\"LET'S GO MELBOURNE\" border=0 src=\"images/uk_flag.gif\"></A>";
echo "</TD>";
echo "<TD align=left vAlign=center width=\"306\"><a href=\"uk.php?id={$row['CatID']}\">{$row['CatName']}</a></TD>";
echo "<TD align=left vAlign=center width=\"100\">< Click to view</TD>";
echo "</TR>";
echo "<TR>";
echo "<TD align=left bgColor=#f2f2f2 vAlign=center width=\"29\"></TD>";
echo "<TD align=left bgColor=#f2f2f2 vAlign=center width=\"406\" colspan=\"2\">{$row['description']}</TD>";
echo "</TR>";
}
}
} else {
?>
<TABLE cellPadding=2 cellSpacing=0 width=480>
<TBODY>
<TR>
<TD align=left vAlign=center width=\"29\">
</TD>
<TD align=left vAlign=center width=\"306\">See <a href="all.php?id=<? echo $row['CatParent']?>">All</a>
| <a href="us.php?id=<? echo $row['CatParent']?>">US</a> | <a href="aus.php?id=<? echo $row['CatParent']?>">Australasia</a></TD>
<TD align=left vAlign=center width=\"100\"> </TD>
</TR></TABLE><BR>
<?
$query = "SELECT * FROM cat1 WHERE CatID = $id";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo "<TABLE BORDER=\"0\" WIDTH=\"480\" CELLSPACING=\"0\" CELLPADDING=\"0\" BGCOLOR=\"#000000\">";
echo "<TR>";
echo "<TD WIDTH=\"400\"> <IMG BORDER=\"0\" SRC=\"images/gob.gif\" width=\"32\" height=\"12\">";
if ( $row['url'] != "" ) {
$urls = explode(", ", $row[url]);
echo " <a href=$urls[0] target=\"_blank\"><FONT COLOR=\"#FFFF00\">{$row['CatName']}</FONT></A>";
echo "</TD>";
}
...more code here
