Hey Everyone,
I am somewhat of an amatuer at PHP and need help. My wife is having me build a website to sell her quilting fabric. Customers are able to search for fabric based on Theme or Color or Manufacturer. Right now, for example, if you search by theme, lets say you want to view all fabric that has a christmas theme to it. I can get it to print my results on the page but my wife doesn't want the customer to have to scroll down the page thru 100 pictures of fabric. What do I do so it will list, lets say, 15 results, then have to hit a continue button, then continue on a new page? Here is my code so far and if you want to try the page I have go to http://www.sadiesquiltingtreasures.com/themepages/christmas.php to view how I am laying it out. Thanks for all yoru help!!
$query = "SELECT * FROM fabric_data where theme1='christmas' or theme2='christmas' or theme3='christmas'";
$result = mysql_query($query);
print("
<table border=1>
<tr>
<td valign=\"middle\" align=\"center\"><font face=\"Arial Rounded MT Bold\" size=\"3\" color=\"#333333\">Fabric</font>
</td>
<td valign=\"middle\" align=\"center\"><font face=\"Arial Rounded MT Bold\" size=\"3\" color=\"#333333\">Name</font>
</td>
<td valign=\"middle\" align=\"center\"><font face=\"Arial Rounded MT Bold\" size=\"3\" color=\"#333333\">Manufacturer</font>
</td>
</tr>
");
while($myrow = mysql_fetch_array($result)) {
$title=$myrow[title];
$manufacturer=$myrow[manufacturer];
$image1=$myrow[image1];
$image2=$myrow[image2];
print("
<tr>
<td align=\"center\">
<a href=$image2><img src=$image1></a><br>
<font face=\"Georgia\" size=\"1\" color=\"#0000FF\">click to view collection</font>
</td>
<td valign=\"middle\" align=\"center\"><font face=\"Arial Rounded MT Bold\" size=\"3\" color=\"#333333\">$title</font>
</td>
<td valign=\"middle\" align=\"center\"><font face=\"Arial Rounded MT Bold\" size=\"3\" color=\"#333333\">$manufacturer</font>
</td>
</tr>
");
}
print("
</table>
");
?>
