<center>Page:
<?php
$query = “SELECT Pages FROM Boxes”; $result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
for ($count == 1; $count <= $row[‘Pages’]; ++$count) {
echo "<a href=‘$count.php’ rel=‘$name’ title=‘$name’>$count</a> ";
}
?>
</center>
the table in the database is layed out this way e.g:
Letter Name Pages
A Apple 1
A Aeon 1
D Dave 4
S Same 2
Using this script I am able to fetch the number of pages from the database and render them as links but one thing I am still unable to do with it is match the name with the name from the page to obtain the specific number from that row of the table for that product.
How would I obtain such results?