andy, this should be pretty basic - just try something along the lines of

1. SELECT country/codes from DB [1]
2. loop thru those results [2]
        a. check if a file called "country code"-map.gif exists[3], if it
does,
                rename[4] it to matching "country name"-map.gif
        b. if not, output (so you know what has and hasn't worked)
3. done

useful functions
[1] mysql_query("SELECT * FROM countries ORDER BY country_code");

[2] while ($thisCountry = mysql_fetch_array($result)) {

[3] if (file_exists($thisCountry["country_code"] . "-map.gif")) {

[4] rename($thisCountry["country_code"] . "-map.gif",
$thisCountry["country"] . "-map.gif");


HTH

Beau



// -----Original Message-----
// From: Andy [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 13 March 2002 8:47 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Renaming files after a name in a db field possible?
// 
// 
// Hi there,
// 
// I am wondering if this is possible in php:
// 
// I have a whole bunch of files named after countrycodes. E.g. 
// CA-map.gif
// 
// Now I would like to rename those files after the country. 
// This is listed in
// a dbtable containing the countrycode and countryname. E.g. 
// CA - Canada
// 
// How could I generate a php script which scannes the dir for matching
// Countrycode patterns and renames the filename ?
// E.g.: Make out of CA-map.gif -> canada-map.gif?
// 
// Thanx for any hint,
// 
// andy
// 
// 
// 
// -- 
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
// 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to