I am trying to return the results of all square footage between 25 and 50 sqfoot. Currently this is my code:

<?php

mysql_connect (localhost, db_name, db_password);

mysql_select_db (db_name);
if ($location == "")
{$location = '%';}
if ($sqfoot == "")
{$sqfoot = '%';}
if ($type == "")
{$type = '%';}
$result = mysql_query ("SELECT * FROM sizes
WHERE sqfoot LIKE '$sqfoot'
AND type LIKE '$type%'
AND location LIKE '$location%'
ORDER BY `price` DESC
");

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

do {
echo '<table cellpadding="15" valign="center" border="0">';
echo '<tr><td WIDTH=70 ALIGN="center">';
print $row["type"];
echo '</td>';
echo '<td WIDTH=70 ALIGN="center">';
print $row["sqfoot"];
echo '</td>';
echo '<td WIDTH=70 ALIGN="center">';
print $row["dimensions"];
echo '</td>';
echo '<td WIDTH=70 ALIGN="center">';
print $row["unit"];
echo '</td>';
echo '<td WIDTH=70 ALIGN="center">$';
print $row["price"];
echo '.00</td>';
echo '<td WIDTH=100 ALIGN="left">';
echo '<a href="locations.htm">';
print $row["notes"];
echo '</a>';
echo '</td></tr>';
echo '</table';
} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>