Hi
I have a database with the 2 following colums : ID and filename
1 the first filename
2 the second one
3 another name number3
4 yet another:good one
5 my/filename
With this table I want to build static HTML files : like :
the_name_of_my_file_ID.html
So for my five lines it sould be
the_first_filename_1.html
the_second_one_2.html
another_name_number3_3.html
yet_another_good_one_4.html
my_filename_5.html
So I have made a rule to make some replaces :
$filename =~s/[ ,()'?".\/+-:]/_/g;
$filename =~s/[éèê]/e/g;
$filename =~s/[àâ]/a/g;
$filename =~s/ô/o/g;
$filename =~s/î/o/g;
$filename =~s/ç/c/g;
$filename =~s/____/___/g;
$filename =~s/___/__/g;
$filename =~s/__/_/g;
$filename =lc($filename);
(maybe it could be improved)
It works great : except when I put the : (that I want to be replaced by a underscore linke in the line4) : then all the numbers that are in the URL are not displayed. For example I will have another_name_number_.html for the line 3
Could you halp? have you an idea?
Txs FMP
I have a database with the 2 following colums : ID and filename
1 the first filename
2 the second one
3 another name number3
4 yet another:good one
5 my/filename
With this table I want to build static HTML files : like :
the_name_of_my_file_ID.html
So for my five lines it sould be
the_first_filename_1.html
the_second_one_2.html
another_name_number3_3.html
yet_another_good_one_4.html
my_filename_5.html
So I have made a rule to make some replaces :
$filename =~s/[ ,()'?".\/+-:]/_/g;
$filename =~s/[éèê]/e/g;
$filename =~s/[àâ]/a/g;
$filename =~s/ô/o/g;
$filename =~s/î/o/g;
$filename =~s/ç/c/g;
$filename =~s/____/___/g;
$filename =~s/___/__/g;
$filename =~s/__/_/g;
$filename =lc($filename);
(maybe it could be improved)
It works great : except when I put the : (that I want to be replaced by a underscore linke in the line4) : then all the numbers that are in the URL are not displayed. For example I will have another_name_number_.html for the line 3
Could you halp? have you an idea?

Txs FMP