This is actually very easy. Change the content type of the document that
you send back and then just send all the data back in a table.
Make the first line of your php ?header(content-type:
application/vnd.ms-excel) ? and only send a table, no html etc.
Regards,
Gary SuperID Huntress
The way I do it is use this header command:
? Header ('Content-Type: application/vnd.ms-excel'); ?
Below that you can use a normal HTML table to lay out your data. Make sure
you only use tabletr and td tags, there should be no html or body
tags in the page.
D'Arcy
- Original Message
Jerry,
Thats a reasonably serious hardware platform, you should not encounter 30
second delays, did you compile mysql yourself or use a pre-compiled
binary...
Sid
-Original Message-
From: PR [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, August 19, 2001 4:28 PM
To: [EMAIL PROTECTED]
David Herring writes:
Good morning,
Let me first start by praising the MySQL documentation. It is
excellent - both in content and in it's indexed, linked, and
searchable layout.
On that later point, I would like to know how you acheived this ?
What tool(s) was used to create the
I don't know, I would have to check with my progammer on that one to be
sure... does this help
mysql -V
Ver 11.15 Distrib 3.23.40, for unknown-freebsdelf4.2 (i386)
[EMAIL PROTECTED] writes:
Jerry,
Thats a reasonably serious hardware platform, you should not encounter 30
second delays, did
Carsten H. Pedersen writes:
...
Having 27 indexes and using queries with LIKE %...% is a nice
recepee for slowness.
Why should having 27 indexes slow down a SELECT?
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
Philip Mak writes:
On Sun, 19 Aug 2001, Lars Bruun Hansen wrote:
mysql show tables from test;
++
| Tables_in_test |
++
| MyTable|
++
mysql alter table MyTable add (y char(1));
mysql show tables from test;
I'm trying to create a mysql statment (in a php page) that says:
? if (prof_exp1 = not null)
then ? h3 my header /h3 li ? printf(prof_exp1) else
if (prof_exp2 = not null) then ? li ? printf(prof_exp2) else
if (prof_exp3 = not null) then ? li ? printf(prof_exp3) else
if (prof_exp4 = not null)
On Sun, 19 Aug 2001, Sinisa Milivojevic wrote:
If this is happening on Windows, we truly can not do anything about
it.
You could help there by forcing all table names to be lower-case by
starting mysql service with a corresponding option.
No, it's happening on Linux. Here's a transcript of
Description:
When a field contains multiple lines (delimited by \n)
SELECT ... WHERE xxx like %xxx% is no longer case
insensitive.
How-To-Repeat:
create table test (
text blob
);
insert into test values (Hello\nWorld\nTest);
# This returns nothing
select *
I have made a mysql server on my linux box. and via Myobdc I access it from a C++
programm I made.. I can see the records.. but If I change one.. I get the error:
No Cursor name availible
I dont know if it is in my program or some premission I set wrong in mysql.. If
anybody can help me
Greetings!
I'm trying to install Apache 1.3.20 and MySql 3.23.41.
During the make of Apache I get the following errors then make exits with
Errors 1 and 2.
/usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function
'my_uncompress':
Hi !!
)-Original Message-
)From: qball cow [mailto:[EMAIL PROTECTED]]
)Sent: Sunday, August 19, 2001 10:50 AM
)To: [EMAIL PROTECTED]
)Subject: Fw: need help
)
)
)I have made a mysql server on my linux box. and via Myobdc I
)access it from a C++ programm I made.. I can see the records..
Hi,
On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote:
At the moment, what I am doing is:
execute LOCK TABLES foo READ
select info from foo
//next lock implictly unlocks previous one
//as it's done by the same thread/process
//chances of conflicts
Hi
I'd like to know if it is possible to scp the database files to a
backup server while mysql is still running on both machines?
Alternatively, is there any replication mechanism to keep the backup
server up to date without shuting down mysql?
--
Best regards
Michael Großegesse
The data wouldn't need to be stored for any longer than two to three months,
so that shouldn't be a problem...what about my query to get all members that
have not read the mailing, is that possible (assuming I don't use the
reverted logic you were talking about).
Daren Cotter
CEO,
Description:
Text that may or may not be added to the MySQL manual
How-To-Repeat:
Fix:
Hello,
As there is a description about using an SSH tunnel with Windows
in the MySQL doc, I thought a text about using an SSH tunnel with
UNIX might be in order. If you think the text below might
Hi,
I notice a problem with Win32 MySQLGUI 1.7.5. When I get the
result for the query. I see the escape character \ was not removed
in the result table window. Anybody notice the same problem?
Thanks,
Shu
-
Before posting,
At 0:17 Uhr +0200 20.8.2001, David Tonhofer wrote:
4) Make sure user 'fred' has an account on machine 'foo'. Unfortunately
this must be an account with a shell :-(
You could probably write a pseudo-shell and put that into /etc/passwd (i.e.
#!/usr/bin/perl
while(STDIN){exit if /^exit$/m;
On Sun, Aug 19, 2001 at 07:44:40PM +0200, Greennet wrote:
Greetings!
I'm trying to install Apache 1.3.20 and MySql 3.23.41.
During the make of Apache I get the following errors then make exits with
Errors 1 and 2.
i know this is easy for some of you guys,
im just starting making some tables and column..
and can't figure out how, ive read the manual and can't seem
to understand it yet fully.
just want to try this but can't seem to work..
i tried creating a table and a column..
like..
mysql CREATE
Is there a way to have MySQL label columns returned
from a select query with the complete column name, in
table.column format?
So if a column name is id, which is in the main table,
can MySQL return main.id instead of just id.
Sure I could alias each column, but if there is 30
columns, that's
John,
I got problem using this new release. When I opened the connection
dialog, I typed in the host name, database name and user name * password.
I specified a database other than mysql. But I always got the error saying
Access denied for user 'xx' to database 'mysql'. I think mysql is
mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
- species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
Straight from
http://www.mysql.com/doc/C/r/Creating_tables.html
Look over
http://www.mysql.com/doc/index.html
Enjoy
M;)
-Original Message-
From: louie
24 matches
Mail list logo