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 >>title 156 >>publisher 80 >>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
