I have a table called 'tblshopping' on a database called 'shopping'. I also have the following columns:
Col 1 - UniqueIdentifier
Col 2 - Store
Col 3 - Item
I'm trying to get the following code
echo "<table width=\"600\" cellpadding=\"2\" cellspacing=\"0\" border=\"0\" bordercolor=\"#000000\">\n";
echo "<tr>\n";
echo "<td bgcolor=\"#ccccff\" style=\"border-top-style: solid; border-top-width: 1\" style=\"border-right-style: solid; border-right-width: 1\" style=\"border-bottom-style: solid; border-bottom-width: 1\" style=\"border-left-style: solid; border-left-width: 1\" id='header'><p align=center>Jewel</td>\n";/*CHANGE STORE NAME*/
echo "</tr>\n";
echo "</table>\n";
to only show up (and to only show up once, I don't want this to show up each time there's a value) if and only if there is a value of 'Jewel' in any of the rows in the 'Store' column but I'm not sure how to do that. The best I can think of is something along the lines of:
If (Any of the rows in the table 'tblshopping' has a value of 'Jewel' in the 'Store' column)
Help?