Re: [PHP-DB] How to get data from mysql to .csv?

SELECT INTO OUTFILE http://www.mysql.com/doc/S/E/SELECT.html ex: SELECT a,b,a+b INTO OUTFILE "/tmp/result.text" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM test_table; also useful - LOAD DATA INFILE http://www.mysql.com/doc/L/O/LOAD_DATA.html olinux ---

RE: [PHP-DB] "resource ID #3"

Jonathan, most (all?) of the database query-related functions in PHP return a "Resource ID" which contains the data resulting from your query. To access that information, you need to pass the Resource ID thru a function like (assuming u r using MySQL) mysql_fetch_array() or mysql_fetch_row() Have

[PHP-DB] "resource ID #3"

I am a newbie to php (as i have announced several times on this bulletin board =) so I thank you all for your help. Mi problemo: I have a database of events going on at local colleges. The names of the tables are the abbreviated names of the colleges. I grab those with a 'SHOW TABLES' command

[PHP-DB] Re: Select string.

Single quotes within the select work fine. $login = mysql_query("SELECT * FROM Users WHERE Username = '$User_Name'"); On Thu, 11 Jul 2002 06:47:54 +1200, Shiloh Madsen wrote: > Yet another thing i need some quick help with. What is the proper way to > generate a select string in php. I know if

Re: [PHP-DB] phpMyAdmin for Windows?

Thanks, I didn't know that phpMyAdmin could connect to another server remotely. I will give it a try. Mark _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com [EMAIL PROTECTED] -- PHP Database Mailing List (h

Re: [PHP-DB] phpMyAdmin for Windows?

If you have a local webserver with PHP installed, all you should need to do is install phpMyAdmin on your local server and configure phpMyAdmin to look for the databases on the remote machine. Start up your web browser, go to the phpMyAdmin URL that you just installed on your local machine, and y

RE: [PHP-DB] phpMyAdmin for Windows?

phpMyAdmin uses PHP and PHP is available for windows. So if I understand your question, the answer is yes, there is something LIKE phpMyAdmin for Windows. It is not a windows application though. <>< Ryan -Original Message- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday,

[PHP-DB] phpMyAdmin for Windows?

I have a site that is on a Windows Server :< and having problems with the Hoster giving me telnet access to Admin MySQL. Is there some thing like phpMyAdmin for Windows. I want to put it in a folder on my site to manage the DB. I thought of developing my own, but why build it if it exist alread

[PHP-DB] MSSQL functions vs. ODBC functions

I am not sure if this question has been asked before, If so sorry for asking again. I have a site that the Client is moving from a MySQL db to Microsoft SQL Server. Is it better to setup an ODBC connection to SQL Server and use the ODBC functions OR to use the MSSQL functions. If I have the choi

RE: [PHP-DB] Date comparison problem

Hi, Assuming your dates have the format you specified and that you only want to compare dates, not time aswell. $str_sql = "SELECT something FROM mytable WHERE LEFT(my_datetime, 10) = '" . str_replace("/", " ", $form_date) . "'"; or if day / month is reversed in MSSQL $str_sql = "SELECT somethin

[PHP-DB] php-security

Hi all! One can see in every php manual and install hint, that you have to consider security issues if you install php as a CGI, but I cannot really imagine what this means. What security issues? Can someone tell me an example, what can happen? Best regards, Gabor -- PHP Database Mailing Lis

Re: [PHP-DB] RH7.3+Oracle9i(9.2.0)Client+PHP4.2.1+Apache1.3.26

in a76999.pdf [ ORA-00909 invalid number of arguments Cause: An Oracle function was referenced with an incorrect number of arguments. All Oracle functions, except for SYSDATE, require at least one argument. Action: Correct the syntax of the function by entering the required number of arguments. ]