Placing numbers beside links

[david4ie]

Hello

I am writting a simple links scripts for my site and i would like to number the links.

For example
1. link 1
2. link2
3. ... and so on

I was wondering how you would do this using php.

Here is the code:

<?php


$mysql_db = "links"; ////////// The name of the database you are using
$mysql_u = "root"; /////////// Your mysql user name
$mysql_p =  "" ; ///////////your mysql password


MYSQL_CONNECT("localhost","$mysql_u","$mysql_p");
mysql_select_db("$mysql_db");

$query  = "SELECT url,title FROM tv WHERE active = 'yes'";
$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result))
{

$menu = "<a href=\"show.php?p={$row['url']}\">{$row['title']}</a><br>" ;

echo ("$menu");

////////////////////     
}
MYSQL_CLOSE();

?>

Thank you,

[bogu]

$i=1;
while ($row = mysql_fetch_assoc($result))
{

$menu = ($i++).". <a href=\"show.php?p={$row['url']}\">{$row['title']}</a><br>" ;

echo ("$menu");

////////////////////     
} 

[david4ie]

Works great thank you

[bogu]

Dont forget to mark this thread RESOLVED ...:p

[greenie2600]

Better yet, follow proper semantic markup practices and write your HTML as an ordered list:

<ol>
    <li><a href="http://www.example.com">example.com</a></li>
    <li><a href="http://www.google.com">Google</a></li>
</ol>