I have a php website connecting to mysql database.
How can i have a user export his database through
the webpage to csv format?
I would like the user to have a button he can press
that would pop up a
save as screen so he can save his database.
The PHP code to do this would look something
--- HACKATHORN, TODD (SWBT) [EMAIL PROTECTED] wrote:
Don't know if this will help, but this is how I
offer web clients to save
as excel in cold fusion:
cfif #ViewInExcel# is Y
cfcontent type=application/vnd.ms-excel
/cfif
the key is to change the content like above. I am
not
Sorry, I didn't mean to send that first message; I hit
send by mistake. This is the real message.
I was delighted to discover how easy it is to import
csv files with phpMyAdmin - until I got the following
error message:
#1148 - The used command is not allowed with this
MySQL version
I found
P.S. I should add that I'm not trying to import data
between computers or to an online site. This operation
involves nothing but me and my computer.
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
Glyndower schrieb am Freitag, 3. August 2001, 05:37:15:
The error message says :MySql said: qUERY WAS EMPTY. When I try to import
this data.
looks like phpMyAdmin does not get the correct query. You have
the source code of phpMyAdmin. Look into that, insert some
debugging code and fix the
I've included my text file as an attachment, but a sample of that data is
below, for those who arn't playing with attachmnets nowadays... :)
I'm using phpmyadmin and I' (still) trying to import a text file into an
existing table. I've included the feils names in the attachment for
reference,
i want to import a series of text files into a MySQL database..
can anyone point in the direction of good documenation on this?..
thanks in advance..
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Fri, Jun 01, 2001 at 03:08:53PM -0400, Longo, Joseph wrote:
i want to import a series of text files into a MySQL database.. can
anyone point in the direction of good documenation on this?..
Search for LOAD DATA in the manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny,