[PHP-DB] Re: question in ADODB

2003-02-21 Thread Philippe Saladin
yes, but can you tell me how? I have read the manual, but they didn't tell how to do so! Look at testdatabases.inc.php in the adodb release. Basically, you would have to write something like : include(adodb.inc.php); $conn = NewADOConnection('ado_access'); $conn-debug = TRUE; // useful for

[PHP-DB] Getting results from MySQL

2003-02-21 Thread Anders Mellström
I have a PHP-MySQl-problem. I would be very greatful if anyone would help me. I am - with the following code - trying to get results from a database. The problem isn't recieving the results, it's where i get the results. All the information is placed far down on the site, not in top. If you're

[PHP-DB] Re: php/mysql query

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Julie Keywell) writes: I am querying our database for 11,000 different zip codes and it seems to be overloading MySQL. However, common sense says it shouldn't. My question is: When needing to query 11,000 things, is it best to make 1 SQL statement that has 11,000 ors, or

[PHP-DB] Re: NotesSQL via ODBC in PHP

2003-02-21 Thread MH
Steve, I have used NotesSQL succesfully to MS Access and MS SQL, but not with PHP. The NotesSQL gives you a very basic SQL function set and to my opinion its not even worth trying it. This was with Notes 4.5.2. It could be better in later versions, I don't know. ODBC works fine, I have connect

[PHP-DB] Re: Getting results from MySQL

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Anders mellström) writes: I have a PHP-MySQl-problem. I would be very greatful if anyone would help me. I am - with the following code - trying to get results from a database. The problem isn't recieving the results, it's where i get the results. All the information is

[PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Snijders, Mark
hello, does anybody know if it's possible (without php) to export data from mysql to a cvs file, so i can import it in excel??? so is it possible, and if yes.. how? thanks kinds regards, Mark Snijders -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: mysql to cvs file to excel

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Mark Snijders) writes: does anybody know if it's possible (without php) to export data from mysql to a cvs file, so i can import it in excel??? Not a cvs file, that's for sure, but I guess you mean csv. You can of course script this with other languages than php, but you can

[PHP-DB] Re: question in ADODB

2003-02-21 Thread pei_world
thank you very much -- Sincerely your; pei_world ( .::IT::. ) Philippe Saladin [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... yes, but can you tell me how? I have read the manual, but they didn't tell how to do so! Look at testdatabases.inc.php in the

[PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
Has anyone found a way to import data through ssl into a php script? If I can pull xml formatted data through a secure socket it will save some major headaches with a problem I need to solve. $url = file(https://www.mydomain.com;); Would be ideal, but it does not work Ryan Ryan Jameson

Re: [PHP-DB] file and https

2003-02-21 Thread Jeffrey_N_Dyke
This works as of 4.3 with fopen(https://myserver.com). but i dont' think it works with file(https://myserver.com)...i may be wrong, of course. HTH Jeff

Re: [PHP-DB] file and https

2003-02-21 Thread Paul Burney
on 2/21/03 9:52 AM, Ryan Jameson (USA) at [EMAIL PROTECTED] appended the following bits to my mbox: Has anyone found a way to import data through ssl into a php script? If I can pull xml formatted data through a secure socket it will save some major headaches with a problem I need to solve.

[PHP-DB] Firebird driver

2003-02-21 Thread Philippe Makowski
Is there a plan to have a Firebird driver ? Firebird is no longer the same as Interbase, it will have it's own libraries when the 1.5 version will be release (there is an 1.5 beta version now) Thanks -- Philippe Makowski Firebird serveur SQL open-source en français http://firebird-fr.eu.org Ma

RE: [PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Bruno Pereira
I had the some problem and someone told me this What is your problem exactly? Have you investigated the MySQL manual under: LOAD DATA INFILE SELECT ... INTO OUTFILE ? And it realy helped. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Snijders, Mark

Re: [PHP-DB] PHP4 on Windows using MSSQL

2003-02-21 Thread Kevin Gordon
Hi Coolio Accessing the Windows NT server from Windows and Linux no longer causes session errors (which were like: can not find session file, header already sent and something about cookies). Trying to access Linux Server (which previously worked 100%). now gives errors (for example: Fatal error:

[PHP-DB] Re: NotesSQL via ODBC in PHP

2003-02-21 Thread Stefan Haas
Hi MH, thanks for your comment, but it seems the NotesSQL-driver is basically fine, as I vcan access the Notes-DB from QTODBC, Access and others, but NOT from php. Do you anybody involved in the ODBC development? Thanks Steve Mh schrieb: Steve, I have used NotesSQL succesfully to MS Access

RE: [PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
Thanks all.. John - What do you mean have SSL installed? Does PHP have a SSL module? I'm already running 4.3.1 so I'm fine there. Also, this is quite database related as the intention is to access data on a remote server through a secure connection. XML is arguably a database protocol. :-)

[PHP-DB] testing the validity of a link

2003-02-21 Thread Matt
Does anyone know of a function, or a way for PHP to test to see if a given link is valid (meaning that the linked page actually exists). Please let me know if you know of a way. Thanks. Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: testing the validity of a link

2003-02-21 Thread Peter Beckman
You could do an fopen on the URL and see if the results contain the string 404 not found or something. Read these pages: http://www.php.net/manual/en/function.fopen.php http://www.php.net/manual/en/wrappers.php http://www.php.net/manual/en/function.stream-get-meta-data.php Looks

[PHP-DB] How to find the autoincremented number?

2003-02-21 Thread David Chamberlin
Hey, Most of the tables I use identify things using an id which is auto-generated using autoincrement. However I can't seem to figure out a good way to find what value was generated for the ID. For example, let's say I generate a new entry and want to e-mail out a link to it and the link

Re: [PHP-DB] How to find the autoincremented number?

2003-02-21 Thread Leif K-Brooks
http://www.php.net/manual/en/function.mysql-insert-id.php David Chamberlin wrote: Hey, Most of the tables I use identify things using an id which is auto-generated using autoincrement. However I can't seem to figure out a good way to find what value was generated for the ID. For example,

Re: [PHP-DB] How to find the autoincremented number?

2003-02-21 Thread David Chamberlin
Aha. I had seen that before, but disregarded it because I was trying to just use pearDB calls instead of the mysql calls. However what I noticed this time when looking through there is that there's a LAST_INSERT_ID() that I could use in a query. e.g., function addNewEntry( $stuffToPutIn ){