RE: [PHP] Newbie Question

On the same note I recommend phpMyAdmin(www.phpmyadmin.net). Its interface is quite useful especially when you have multiple DB's to manage on the same server. Dan -----Original Message----- From: Van Andel, Robbert [mailto:RVanAndel@chartercom.com] Sent: Thursday, August 21, 2003 12:24 PM To: php-general@lists.php.net Subject: RE: [PHP] Newbie Question You can download PHPMySQL and locate it in a secure portion of your site. It's an excellent gui interface into mySQL. This tool will allow you to upload the script file and insert the data. I'm sorry, but I don't know the URL where to get it. Check sourceforge. Robbert van Andel -----Original Message----- From: Phil King [mailto:phil@phil-king.com] Sent: Thursday, August 21, 2003 7:40 AM To: php-general@lists.php.net Subject: [PHP] Newbie Question 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php