checking a query to see if record with a certain type exists

[synergy]

Here's the logic:

If records exist in the database with the type of "Porsche_Cabriolet" then it prints what records have that type. Otherwise, it should print "None in inventory at this time"

I can't translate this into PHP 🙁 Any suggestions?

$result = mysql_query("SELECT * FROM inventory WHERE Sold = '0' AND Type = 'Porsche_Cabriolet' ORDER BY Year DESC, Miles ASC" , $db);

print "	<center><img src='images/porsche_cabriolet.gif'><BR>\n";

while($myrow = mysql_fetch_array($result, MYSQL_ASSOC))
{

	print "	<table border=0 width=100%>\n";
	print "		<tr>\n";
	print "			<td height='2' rowspan='5'>\n";
	print "			</td>\n";
	print "			<td colspan='3' height='2'>\n";
	print "			</td>\n";
	print "		</tr>\n";
	print "		<tr>\n";
	print "			<td width='38%' height='17'>\n";
	print 				$myrow['Year'];
	print "			</td>\n";
	print "			<td width='22%' height='17'>\n";
	print 				$myrow['Miles']." Miles"; 
	print "			</td>\n";
	print "			<td width='22%' height='10' rowspan='3'>\n";
	print "			</td>\n";
	print "		</tr>\n";
	print "		<tr>\n";
	print "			<td width='38%' height='19'>\n";
	print 				$myrow['Model'];
	print "			</td>\n";
	print "			<td width='22%' height='19'>\n";
	print 				$myrow['Price'];
	print "			</td>\n";
	print "		</tr>\n";
	print "		<tr>\n";
	print "			<td width='38%' height='17'>\n";
	print				$myrow['Exterior_Color']." / ".$myrow['Interior_Color'];
	print "			</td>\n";
	print "			<td width='22%' height='17'>\n";
	print 				$myrow['Stock_Number'];
	print "			</td>\n";
	print "		</tr>\n";
	print "		<tr>\n";
	print "			<td colspan='3' height='2'>\n";
	print "			</td>\n";
	print "		</tr>\n";
} 

print "</table>\n";

mysql_free_result($result);

[synergy]

nevermind got it working 🙂 I think sometimes it helps to post code elsewhere and look at it more 😛

[sijis]

you're on the right track, just need to do a few minor changes.

this should work.

$result = mysql_query("SELECT * FROM inventory WHERE Sold = '0' AND Type = 'Porsche_Cabriolet' ORDER BY Year DESC, Miles ASC" , $db);

print "    <center><img src='images/porsche_cabriolet.gif'><BR>\n";
$myrow = mysql_fetch_array($result, MYSQL_ASSOC);

print "<table>";
if ($myrow){
   print "<tr><td>";
   print "None in inventory at this time";
   print</td></tr>;
} else{
  while($myrow){
   // the while loop code here.
   }

}
print "</table>";
mysql_free_result($result);