"Brian e Boothe" <[EMAIL PROTECTED]> wrote on 10/31/2005 10:21:35 PM:
> I.m needing assistance in get a problem Solved , > > What im attempting to do is have MySQL thru asp or PHP look thru > Folders and add to a Mysql database the path and folder name and file > located within that directory into the database, can anyone help me ?? or > give me hints > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.362 / Virus Database: 267.12.6/152 - Release Date: 10/31/2005 > I am mostly confused about you are actually trying to do. I think you are trying to crawl a directory tree with MySQL by calling an ASP or PHP script. I think you have chosen the wrong tool to automate a directory scan. Either PHP or ASP can do the directory navigation work that you describe but MySQL is a database server. Its role in this situation would be to store and retrieve results not to control the process. In ASP, you would instantiate a "Scripting.FileSystemObject" object and use its properties and methods to navigate your directory structures. You would use the ADODB.xxx objects to interact with a MySQL database through a MyODBC driver. I don't know what you would use in PHP to crawl file system folders but many PHP installations have the mysql_xxx functions activated by default. You would not need to use any other objects/libraries/drivers to interact with the MySQL database if you used the native mysql_xxx functions. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
