[PHP-DB] sqlite_seek() problem

2003-07-07 Thread Alan D'Angelo - Media Beat Information Technology
Hello !! When I make a query with sqlite_query() and use sqlite_fetch_array() all works well: Example: $result = sqlite_query('SELECT * FROM test', $conn); while($row = sqlite_fetch_array($resulr, SQLITE_NUM, true)){ $rows[] = $row; } $rows is: Array ( [0] = Array (

[PHP-DB] Re: Buenos dias - Pregunta Oracle

2003-07-07 Thread Philippe Saladin
Quique Notelodigo [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Buenos dias Estoy empezando a trabajar con Oracle y php. Ya he trabajado con Postgres y PHP. Solo tengo una pregunta, muy concreta: Tengo Oracle en una máquina distinta al servidor Linux con Apache+PHP

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-07 Thread Ognyan Bankov
Steve B. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Nadim, It works but not for sites with password window that pops up. I see. That is HTTP Basic Authentication You should use this line: $filename = 'http://someuser:[EMAIL PROTECTED]/'; instead of: $filename =

[PHP-DB] R: [PHP-DB] SQLite

2003-07-07 Thread Alan D'Angelo - Media Beat Information Technology
Download a CHM version of manual !! -Messaggio originale- Da: Gerard Samuel [mailto:[EMAIL PROTECTED] Inviato: domenica 6 luglio 2003 1.16 A: [EMAIL PROTECTED] Oggetto: [PHP-DB] SQLite With respect to the PHP manual, are there any documentation to using this extention? Thanks --

RE: [PHP-DB] Re: OCI_ASSOC returns key with upper case string

2003-07-07 Thread RENAULT, François
hi all , i'm quite new to this mailing list i d like you to test with lowercase object names in Oracle but i don't recommend to use it in general for example (1) create table test1 ( b number ) ; is different from (2) create table test1 ( a number ) ; in oracle , if you don't quote your

Re: [PHP-DB] Re: PHP crashing with using Oracle

2003-07-07 Thread Reuben D. Budiardja
On Monday 07 July 2003 08:47 am, you wrote: HI, how many memory is on your server? I had the same problem... when I incrased memory in the computer, it was working well... I have 1 GB RAM and 2 GB Swap. I thought that should be enough for development box. Here is the output of free:

[PHP-DB] Re: PHP crashing with using Oracle

2003-07-07 Thread Reuben D. Budiardja
[Cross posting to PHP-DEV, sorry if this is inappropriate, but this maybe a bug] On Saturday 05 July 2003 05:28 pm, Reuben D. Budiardja wrote: Hello, I installed PHP-4.3.2 with oci8 and oracle support (using --with-oci8 --with-oracle). I recompile apache-1.3.27 to use the libpthread as

Re: [PHP-DB] Newbie file reading into MySQL

2003-07-07 Thread Jason Wong
On Monday 07 July 2003 07:44, Kim Kohen wrote: Just one question: why are you storing text files containing DATA into a DB? Why not just store the data in the DB and do away with the text files? Thanks for the reply. I can see now my original wording was a bit unclear. I am, in

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-07 Thread Steve B.
Yes I had tried all those below before posting. It sounds like this is the only way to deal with authentication from what I see. In windows it works fine from the browser to include name and pass in url. In Linux it comes back and asks for the pw again. I'd think the only difference would be in

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-07 Thread Adam Voigt
Try CURL: http://us2.php.net/curl On Mon, 2003-07-07 at 10:17, Steve B. wrote: Yes I had tried all those below before posting. It sounds like this is the only way to deal with authentication from what I see. In windows it works fine from the browser to include name and pass in url. In

[PHP-DB] new form of connection with mysql_init() failing

2003-07-07 Thread Allens
Hello, Trying to use this newer form of connection with mysql_init() and mysql_real_connect instead of mysql_connect(). When I try to recode and use this, I get the following: call to undefined function: mysql_init(). What am I doing wrong? mysql_connect() works just fine though. Thanks in

[PHP-DB] Is ****_fetch_row the fastest way to do this?

2003-07-07 Thread Colin Kettenacker
I am using odbc_fetch_row to loop through a SQL select search result row by row. Is this the fastest way to collect the data from the database search result? Is there no way to collect all the data into an array without looping through the search result row by row? Sorry for the newbie

[PHP-DB] csv upload script?

2003-07-07 Thread Aaron Wolski
Hey all, Does anyone know a simple.. out of the box ready go csv upload script to import values into a table? I've looked at hotscripts and couldn't find anything. Any help is appreciated. Thanks! Aaron

Re: [PHP-DB] csv upload script?

2003-07-07 Thread jeffrey_n_Dyke
if it is truley csv, then use MYSQL's LOAD DATA INFILE syntax. granted you've got to have ahold of the text file.its not out of the box, but pretty close. Woudl that work for you? http://www.mysql.com/doc/en/LOAD_DATA.html hth Jeff

RE: [PHP-DB] csv upload script?

2003-07-07 Thread Aaron Wolski
Hey Jeff! Thanks for the info. Unfortunately I don't have permissions setup for this command. Our host has disabled it because of security reasons. This was done some time ago and they weren't willing to change then nor now. Any other thoughts? Oh.. one more thing.. does ANYONE know how to

RE: [PHP-DB] Very confused with query

2003-07-07 Thread Matthew Moldvan
Hi Robin, I think you are not using DISTINCT correctly ... try SELECT DISTINCT whatever instead of the ()s. Also, the use of * and DISTINCT together really makes no sense ... in the SQL, you are saying select only one record, then select everything, which are opposites. Don't mean to be rude,

RE: [PHP-DB] Very confused with query

2003-07-07 Thread Ryan Jameson (USA)
distinct always applies to the entire record set, so if you return 2 fields the two fields together will be distinct. In this case it looks like you want to get rid of distinct and put: group by transaction_user_id at the end. Since you already have MAX(transaction_date), it will work as long

Re: [PHP-DB] SELECT question

2003-07-07 Thread Becoming Digital
The internet is a wonderful resource. http://www.mysql.com/doc/en/SELECT.html Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: Artoo [EMAIL PROTECTED] To: [EMAIL

[PHP-DB] Re: Connect Active Directory using LDAP... please help :)

2003-07-07 Thread The.Rock
Try this and see if it works. I had the same problem until I did a little reading. I had to use [EMAIL PROTECTED] as username then I didn't get the credential errors anymore. hope this helps, its very basic but hopefully it gets you started. * Config.php** ?php

[PHP-DB] MySQL Extention in PHP5.0.0b2-dev

2003-07-07 Thread Adam Lundrigan
Apache 2.0.46 (Win32) PHP/5.0.0b2-dev w/ MySQL 4.1.0 I have a question about the mySQL extension in the aforementioned version of PHP Whenever I try to load the extension thru adding it to PHP.INI like so I get an error extension_dir = C:\Servers\PHP\extensions . . . extension = php_gd2.dll

[PHP-DB] Re: new form of connection with mysql_init() failing

2003-07-07 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hello, Trying to use this newer form of connection with mysql_init() and mysql_real_connect instead of mysql_connect(). When I try to recode and use this, I get the following: call to undefined function: mysql_init(). What am I

[PHP-DB] Re: MySQL Extention in PHP5.0.0b2-dev

2003-07-07 Thread Robert Schmelzer
Hi! Check, if the libMySQL.dll is in a directory, where it can be loaded. For example, add the c:\php5\dlls directory to your path variable. This is because, php_mysql.dll loads the libMySQL.dll. greetings Robert Adam Lundrigan [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]