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 > > > --------------------------------------------------------------------- > 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