This is what I use to generate a comma delimited csv file:
$sql = "SELECT * FROM table INTO OUTFILE 'file.csv'"
." FIELDS TERMINATED BY \',\'"
." ENCLOSED BY \'\"\'";
Hope this helps.
Ruth
- Original Message -
From: "Snijders, Mark" <[EMAIL PROTECTED]>
T
Hi everyone,
I want to dump some data from mysql into a file, and use php to force the browser to
pop a download file window. This seems a simple procedure, but I am having trouble to
make it work with IE. The following is what I did:
ob_start();
$query = "SELE
a guess. I'm assuming you were asking if using connecting via ODBC is
> slower.
>
> See:
> http://www.php.net/manual/en/function.mssql-connect.php
> http://www.phpbuilder.net/columns/alberto2919.php3
>
> for more specific info regarding setup and mssql libraries.
>
> H
Hi Everyone,
I have spent a few hours searching on the internet, but still can not get the
information I need. So I turn to you for help.
I will be doing a web site which has a lot of data from a remote mssql server. The
scripts will be in php and run on Linux. As requirements, the mssql will
This is what I use:
SHOW COLUMNS FROM table LIKE "field"
I use the query result for a select field in HTML table.
Ruth
- Original Message -
From: "Bastian Vogt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 11:41 PM
Subject: [PHP-DB] mysql - enum
> Hi,
>
This is a very good tutorial about authentication using PHP and MySQL. If
you don't use database, you may still learn some thing about sessions from
there:
http://phpcomplete.com/content.php?id=72
Ruth
- Original Message -
From: "Edward Peloke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Thank you again, Wilmar.
As a newbie for OOP, I will keep my option open when I design this
application. I have not come to a conclusion which way is better than
another (I wish I had time to test all possibilities). I appreciate your
comments, and will keep them in mind.
Regards
Ruth
-
Thanks Wilmar, for sharing your experience with me. My problem now is that
I have already got a class to do every thing related to database. If I
don't use this DB class within other classes, I will have a lot of
duplicated code. If I do use the DB class within other classes, I am not
sure if i
Hi All,
Although I am not so new to PHP (not expert either), this is the first time
for me to use PHP class.
I am starting a project, and plan to use partially OOP and partially
traditional programming. I use PHP/MySQL. I have one class, DB_Do, which
does every thing to do with database, and se
; changing it? because registering globals should make $var available again
> (but won't help with problem 1 :)
>
> HTH
>
> Beau
>
> // -Original Message-
> // From: Ruth Zhai [mailto:[EMAIL PROTECTED]]
> // Sent: Wednesday, 24 July 2002 11:39 AM
> // To: [EMA
Hello php friends,
We just upgraded our PHP to version 4.2.1. I realized that $var is no
longer available from www.url.com/myphp.php?var=3 . As instructed in the
document, we have tried two things:
1. I tried to use $_GET('var'), however, I got "Fatal error: Call to
undefined function: array() i
11 matches
Mail list logo