[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 PROTECTE

[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 a

[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 ext

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 P

Re: [PHP-DB] Re: PHP crashing with using Oracle (SOLVED... well, sorta)

2003-07-07 Thread Reuben D. Budiardja
Apparently there is a bug or something with OCI8 extention for PHP-4.3.2. Using the same configuration and everything, I compiled PHP-4.3.1, and 4.2.3 and both worked. I send e-mail to PHP-DEV wondering if this is a known bug that has been reported before. So if anyone has the same experience

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 a

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, bu

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 enca

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

[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

[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 question.

[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 ad

[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** **

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 L

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 hea

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

[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 me

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:

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

2003-07-07 Thread Reuben D. Budiardja
On Sunday 06 July 2003 07:40 pm, Lang Sharpe wrote: > I had to change ext/oci8/config.m4 > Remove the line highlighted in red on this page. > > http://cvs.php.net/diff.php/php-src/ext/oci8/config.m4?login=2&r1=1.37.2.6&; >r2=1.37.2.7&ty=h > > The line is > AC_DEFINE(HAVE_OCI8_SHARED_MODE,1,[ ]) > >

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 ob

[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 -- PHP