$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='showerwall'");
$number=mysql_num_rows($query);
echo "
Shower Wall Tile
";
echo"
";
echo"
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
echo "
";
$count++;
}
echo"
";
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='showerwallgrout'");
$number=mysql_num_rows($query);
echo "
Shower Wall Tile Grout Color
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
echo "
";
$count++;
}
?>
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='floor'");
$number=mysql_num_rows($query);
echo "
Bathroom Floor Tile
";
echo"
";
echo"
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
echo "
";
$count++;
}
echo"
";
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='floorgrout'");
$number=mysql_num_rows($query);
echo "
Floor Tile Grout Color
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
echo "
";
$count++;
}
?>
/*
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='floor' AND statusid='1'");
$number=mysql_num_rows($query);
echo "
Bathroom Floor Tile
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
echo"
";
echo"
";
echo "";
echo"
";
*/
?>
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='showerfloor'");
$number=mysql_num_rows($query);
echo "
Shower Floor Tile
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
?>
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='showerstripe'");
$number=mysql_num_rows($query);
echo "
Shower Stripe
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
?>
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='showerdoor'");
$number=mysql_num_rows($query);
echo "
Shower Door
";
echo "";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
?>
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='showerfaucet'");
$number=mysql_num_rows($query);
echo "
Shower Faucet
";
echo "";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
?>
/*
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='cabinet'");
$number=mysql_num_rows($query);
echo "
Cabinet
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
*/
?>
/*
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='mirror'");
$number=mysql_num_rows($query);
echo "
Mirrors
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
*/
?>
/*
$query = mysql_query("SELECT * FROM myMats WHERE layoutid='$layoutid' AND matcat ='wall'");
$number=mysql_num_rows($query);
echo "
Wall Color
";
$i = 0;
$count = 0;
while ($post = mysql_fetch_assoc($query)) // get data and display image
{
$i++;
if($count==8) // if 5 images send br return
{
echo "
";
$count = 0;
}
$matname=$post['matname'];
//echo$matname;
echo "
";
$count++;
}
*/
?>