Do While

[furious5]

I'm being a bit thick but how can I incorporate this bit of code in to the do while loop below?

Basically I am wanting to exclude any records that have a category = coming soon, from being printed out on screen

$category != "COMING SOON";

if ($found>0) {
print("<table width=\"395\" border=0 cellpadding=3 cellspacing=1>");					
do	{
$description=$row["description"];
$shortdesc=substr($description, 0, 45); 
$shortdesc.="....";		  

print("<tr><td width=\"310\" class=\"searchlist\"><a class=\"mainbodytext\" href=\"description.php?prodid=".$row["ID"]."\">".$row["make"]."<br>".$shortdesc."</a></td><td width=\"55\" align=left class=\"searchlist\"><b>£".$row["price"]."</b></td><td width=\"30\" class=\"searchlist\" align=\"center\"><a href=\"description.php?prodid=".$row["ID"]."\"><img src=\"images/cart.gif\" border=0></a></td></tr>");
}
while ($row=mysql_fetch_array($result));
print("</table>");
}

Or would it be easier to excluse at the SQL query - if so how would I go about excluding the category coming soon???

[Selinaar]

Originally posted by furious5

Or would it be easier to excluse at the SQL query - if so how would I go about excluding the category coming soon???

Hi there,

have you tried something like this :

$query = "select id,price,category from products where category NOT like '%coming soon%' order by id ASC";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {

echo "ID : $row[0] - Price : $row[1] - Category : $row[2]<br>";

}

Hope that helps, I am sure there is a more elegant solution for your question - I tried this in a test database and it worked.

[furious5]

I was just have a dense moment.

I used the following SQL to overcome the problem:

SELECT * FROM product WHERE category <> 'COMING SOON' ORDER BY category