Hi, I 'm in the process of modify one of my sites to use PHP/mysql instead of ASP/Ms Access.
The Access database has 200 records in it. I have PWS, mysql and PHP running on my local PC. I have used Navicat from mysqlstudio.com to import the access database into mysql and then exported the data back out as an sql script. The script consists of multiple sql statements like : INSERT INTO mydatabase (id, Description, Department, RetailPrice, PrefSupPartNo, PrefSupplier) VALUES (1, "Bunting Plastic Union Jack 4m", "Flags & Bunting", "2.5", "JFB", "Smiths"); Is there a way of "including" the sql script file into a PHP page or do I have to copy and paste the statements into a PHP page with a "mysql_query" statement after each sql statement, to load these records to my ISP's remote server. p.s My ISP has no GUI interface into mysql so all manipulation is done via PHP. Thanks very much for any guidence. Phil. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
