vigneshn

i am also trying to do with mysql

i need to convert [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--][a href=\"http://www.centraldirectory.net/showcats.php?sbcat_id=49\" target=\"_blank\"]http://www.centraldirectory.net/showcats.php?sbcat_id=49[/a][/quote] to [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--][a href=\"http://www.centraldirectory.net/showcats.php?cat=directories\" target=\"_blank\"]http://www.centraldirectory.net/showcats.php?cat=directories[/a][/quote] i can make use of preg replace functions to remove spaces so no need to worry about that just please do the above modification ie [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--][a href=\"http://www.centraldirectory.net/\" target=\"_blank\"]http://www.centraldirectory.net/showcats.php?sbcat_id=[/a][!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]"a cat number"[!--colorc--][/span][!--/colorc--][/quote] to [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--][a href=\"http://www.centraldirectory.net/\" target=\"_blank\"]http://www.centraldirectory.net/showcats.php?cat=[/a][!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]"name"[!--colorc--][/span][!--/colorc--][/quote] please i will give you the necessay files please post if you are interested i did some editing but i got 404 not found pages so the link should work please thank you

yes i have linux server with MySQL

please visit www.centraldirectory.net the category link are displayed as showcat.php?sbcat_id="somenumber" can you change this to www.centraldirectory.net/category_name/ if you can help me please download index.php and showcats.php [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--][a href=\"http://rapidshare.de/files/18708687/LD.zip.html\" target=\"_blank\"]http://rapidshare.de/files/18708687/LD.zip.html[/a][/quote]