parse url from sql query

[Maller]

Hi i have this script

<?php
$a=mysql_connect("localhost", "root", "pass");
$b=mysql_select_db("counter",$a);

$result = mysql_query('SELECT url, hits FROM misc ORDER BY hits DESC LIMIT 5');
echo 'Top 10 Members:<br><br>';
while ($row = mysql_fetch_assoc($result))
{
    echo $row['url'] . ': ' . $row['hits'] . '<br>';
}
?>

how can i parse the url i extract, to only show the path
I know how to use parse_url() that aint the problem.
It´s more getting it to read $row['url'] so it can be parsed

any help is appreciated

Maller

[jazappi]

use substr to take off the beginning of your url before your print it.

http://us2.php.net/manual/en/function.substr.php

[kingbear]

You can also try something like this:

str_replace("http://www.yourdomain.com", "", $row["url"]);