Re: newbie: MySQL importing data from a variable

Gavin. Try this - put a counter in you loop, and echo the counter along wiht $file. I would wager that your last value for file is "". (I didn't carefully check your logic.) More to the point, you aren't accumulating the file names in $file. As an experiment, try adding $filelist ,= $file; before the echo statement, also echo $filelist to see how it builds. If it is doing what you want, then substitute it for $file in your update statement. REgards - Miles Thompson At 10:26 AM 3/12/01 -0800, Gavin Tong wrote:

Hi, I've been trying to get this script to read a directory and then pass the information into a Mysql table. I can open the directory and print it's contents, or I can get other information from variables passed to the mysql table, but I can't seem to do both. If you have any idea what I've done wrong or have an idea where I can read more about this problem your thoughts will be greatly appreciated. Sincerely, Gavin Tong <?php $handle=opendir('.'); while (false!==($file = readdir($handle))) {

    if ($file != "." && $file != "..") {
        echo "$file\n";
    }

} closedir($handle); $db = mysql_connect("local host", "person", "pasword"); mysql_select_db("photos",$db); $result = mysql_query("insert into template (name) values ('$file')",$db); ?>