mysql_connect("localhost","whatever","qantel69");
mysql_select_db("whatevertheletter");
if(!trim($clr))
$clr = 1;
if($clr == 1)
{
$loc = "solids";
$qry = "select * from garment order by color_code";
}
if($clr == 2)
{
$loc = "borders";
$qry = "select * from border order by border_code";
}
if($clr == 3)
{
$loc = "patterns";
$qry = "select * from pattern order by pattern_code";
}
$res = mysql_query($qry);
while ($rw = mysql_fetch_row($res))
{
echo " $rw[1] | ";
}
?>
|