Custom URL handling (just a little)

[eluser]Jupiter[/eluser]
Now here's what I did:

In routes.php I added

Code:

// CUSTOM ROUTES:

// database is not yet connected, so do it manually:

$dbhost = 'localhost';
$dbuser = 'username';
$dbpassword = 'password';
$dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);

$sql = "SELECT brand_name FROM brand";

$result = mysql_query($sql);

// insert route for every brand here:

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    
    $route[$brand] = "display/brand/".$row["brand_name"];
    $route[$brand.'/:any'] = "display/brand/".$row["brand_name"];

    }

That's not beautiful, but it works. Any ideas?

Peter