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