scripts needed
Our internet provider is starting to host database services. I am the webmaster of our local church and we have a library of 1000 books, tapes, etc. in a small Foxpro database. I need a script to create a MySQL table with the following character fields: field length section 28 author1 42 author2 42 title156 publisher80 number 10 authorsort 70 I also need a script to import my Foxpro data into a MySQL table. I'm going to just update my Foxpro table and refresh the MySQL table manually - easier that way in this case. Also, I'll need a HTML form and script to allow people to search by title, author, publisher, etc and to let them see the results. Pretty standard stuff really. I don't see the point of reinventing the wheel so would one of you have a couple of scripts that I can use or adjust ? It will be running on a UNIX platform. Thank you very much. Edwin Davidson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: scripts needed
To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html I do not believe that mysql will read the foxpro db format. Dump your foxpro table data into a text file and use mysqlimport to pull the data into your mysql table. See: http://www.mysql.com/doc/m/y/mysqlimport.html As far as add, edit, search, etc., you may want to take a look at phpMyEdit at: http://phpmyedit.sourceforge.net/ JR - SallyJo, Inc., is your source for Web Hosting Programming Services. Visit: http://SallyJoInc.com -Original Message- From: Edwin Davidson [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 08, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: scripts needed Our internet provider is starting to host database services. I am the webmaster of our local church and we have a library of 1000 books, tapes, etc. in a small Foxpro database. I need a script to create a MySQL table with the following character fields: field length section 28 author1 42 author2 42 title156 publisher80 number 10 authorsort 70 I also need a script to import my Foxpro data into a MySQL table. I'm going to just update my Foxpro table and refresh the MySQL table manually - easier that way in this case. Also, I'll need a HTML form and script to allow people to search by title, author, publisher, etc and to let them see the results. Pretty standard stuff really. I don't see the point of reinventing the wheel so would one of you have a couple of scripts that I can use or adjust ? It will be running on a UNIX platform. Thank you very much. Edwin Davidson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scripts needed
JR wrote: To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html I do not believe that mysql will read the foxpro db format. Dump your foxpro table data into a text file and use mysqlimport to pull the data into your mysql table. See: http://www.mysql.com/doc/m/y/mysqlimport.html As far as add, edit, search, etc., you may want to take a look at phpMyEdit at: http://phpmyedit.sourceforge.net/ JR - SallyJo, Inc., is your source for Web Hosting Programming Services. Visit: http://SallyJoInc.com -Original Message- From: Edwin Davidson [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 08, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: scripts needed Our internet provider is starting to host database services. I am the webmaster of our local church and we have a library of 1000 books, tapes, etc. in a small Foxpro database. I need a script to create a MySQL table with the following character fields: field length section 28 author1 42 author2 42 title156 publisher80 number 10 authorsort 70 I also need a script to import my Foxpro data into a MySQL table. I'm going to just update my Foxpro table and refresh the MySQL table manually - easier that way in this case. Also, I'll need a HTML form and script to allow people to search by title, author, publisher, etc and to let them see the results. Pretty standard stuff really. I don't see the point of reinventing the wheel so would one of you have a couple of scripts that I can use or adjust ? It will be running on a UNIX platform. Thank you very much. Edwin Davidson You could also try http://php.resourceindex.com to see if any of the scripts there fit the bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php