Match name for name to obtain the specific number from db

<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?


SELECT Pages 
FROM Boxes
[B][COLOR="Red"]WHERE Name = 'REDmarkX'[/COLOR][/B]

Of course you’ll have to get the name you want to extract from somewhere ($_POST, $_GET or $_SESSION for example).

Thank you… it is functional. :slight_smile: