[PHP-DB] Re: PHP-dbase conversion

2002-11-28 Thread J.Veenhuijsen
The dbase file must be in the webserver path. Sean wrote: Hi all, I have to convert an old dbase5.0 database server to mysql database which is located in the web server. The problem is when i use dbase_open function to read data from the database server it will give this error Warning: unable t

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-28 Thread Rick Widmer
At 10:40 AM 11/29/02 +1100, Gavin Amm wrote: hmm, interesting to know the mysql_fetch_array() by default returns an array that's associative AND numeric - very useful to know & something i'll have to look into more, thanks Jason. Using PHP's built in template system... $result_dept = mysql_quer

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-28 Thread Gavin Amm
thanks John, i was thinking along similar lines. that should work well. cheers, Gav -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Friday, 29 November 2002 4:08 PM To: 'Gavin Amm'; 'Php-Db (E-mail)' Subject: RE: [PHP-DB] foreach loop from MySQL select query to HT

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-28 Thread John W. Holmes
> hmm, interesting to know the mysql_fetch_array() by default returns an > array > that's associative AND numeric - very useful to know & something i'll have > to look into more, thanks Jason. > > Thanks also John, puting curley braces around the variables is a valuable > lesson - works wonderfull

[PHP-DB] PHP4.22/OCI8/Netscape 3.63 tnsnames problem...

2002-11-28 Thread David Leach
Hi there, I've having some problems with ORACLE_SID under Solaris 8/PHP 4.22/Netscape 3.63. If I specify the ORACLE_SID, and export it within my environment before webserver startup, php/oracle do not look up the SID within tnsnames.ora. I verified this with truss: Trace output: Fatal NI connec

[PHP-DB] PHP-dbase conversion

2002-11-28 Thread Sean
Hi all, I have to convert an old dbase5.0 database server to mysql database which is located in the web server. The problem is when i use dbase_open function to read data from the database server it will give this error Warning: unable to open database .. Can dbase_open function opens a

[PHP-DB] PHP-Dbase converison

2002-11-28 Thread Sean
Hi all, I have to convert an old dbase5.0 database server to mysql database which is located in the web server. The problem is when i use dbase_open function to read data from the database server it will give this error Warning: unable to open database .. Can dbase_open function opens a

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-28 Thread Gavin Amm
hmm, interesting to know the mysql_fetch_array() by default returns an array that's associative AND numeric - very useful to know & something i'll have to look into more, thanks Jason. Thanks also John, puting curley braces around the variables is a valuable lesson - works wonderfully - cheers. i

RE: [PHP-DB] mysql problem

2002-11-28 Thread John W. Holmes
So what's the problem? The data doesn't appear in the table? Did you try to see if mysql_error() had anything in it after your query? ---John Holmes... > -Original Message- > From: Bill Arbuckle, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 28, 2002 5:56 PM > To: [EMAIL PROTE

RE: [PHP-DB] mysql problem

2002-11-28 Thread Peter Lovatt
Hi you need quotes around the values mysql_query("insert into tblquotehits (qoption,referer,browser,remoteaddr,dt) values ('$quotetype','$referer','$browser','$remoteaddress','$currentdtstring')",$d b); HTH Peter --- Excellence in internet and open so

[PHP-DB] mysql problem

2002-11-28 Thread Bill Arbuckle, Jr.
Hello all! I am new to php and I am trying to update a mySQL table using php v4.2.3 for Windows. I am using the command: mysql_query("insert into tblquotehits (qoption,referer,browser,remoteaddr,dt) values ($quotetype,$referer,$browser,$remoteaddress,$currentdtstring)",$db); I have read the doc

Re: [PHP-DB] Help with date

2002-11-28 Thread Ignatius Reilly
If you use MySQL: SELECT DATE_ADD( $my_date, INTERVAL n DAY ) AS new_date ; Ignatius - Original Message - From: "Dankshit" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]>; "PHP1" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 6:06 PM S

RE: [PHP-DB] Help with date

2002-11-28 Thread Aaron Wolski
Well... 1 day = 60*60*24 = 86400 You figure it out from there :) Just one example. Aaron -Original Message- From: Dankshit [mailto:[EMAIL PROTECTED]] Sent: November 28, 2002 12:06 PM To: PHP; PHP1 Subject: [PHP-DB] Help with date How can i add days to a date??

[PHP-DB] Help with date

2002-11-28 Thread Dankshit
How can i add days to a date?? Equipe Pratic Sistemas Rodrigo CorrĂȘa Fone: (14) 441-1700 [EMAIL PROTECTED] [EMAIL PROTECTED]

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

2002-11-28 Thread John W. Holmes
> i've looked around the web a bit more & it would appear you can't just use > a > foreach function, apparently you need to use a while{foreach{}} structure. > i > was hoping you could just use the foreach function? > > so this is the code now: > > > -select- > while ($row = mysql_fet

Re: [PHP-DB] Error in retrieving a blob from oracle DB.

2002-11-28 Thread Naif M. Al-Otaibi
So, what can I do to retrieve a blob in oracle? Any one has a code for this. - Original Message - From: "Mark" <[EMAIL PROTECTED]> To: "Naif Al-Otaibi" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 4:37 PM Subject: Re: [PHP-DB] Error in retrieving a blob from oracle DB. > Load()

[PHP-DB] Error in retrieving a blob from oracle DB.

2002-11-28 Thread Naif Al-Otaibi
Hi all, I use the following: 1) Win XP. 2) Oracle personal eddition 8.1.6.0.0. 3) IIS. 4) php-4.2.3-Win32 runs in cgi mode. When I retrieve a blob from my DB, I got the following error: Fatal error: Call to undefined function: load() in c:\inetpub\wwwroot\php1\ora52.php on line 6

[PHP-DB] RE: Access to Oracle db from PHP script

2002-11-28 Thread Ford, Mike [LSS]
Sorry, I think you'd be better off asking this on the php-db mailing list, so I've copied it into this reply -- I didn't set up the Oracle I connect to, and I just make use of connect functions written for the purpose by the Oracle expert on the next desk! > > I have find your e-mail at this lin

[PHP-DB] How to setup LDAP on win2000/IIS5?

2002-11-28 Thread J.Veenhuijsen
What do I need to setup an LDAP server on win2999/IIS5/PHP I tried QcsLDap but this didn't work. Thanks Jochem -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] ODBC,PHP and LINUX

2002-11-28 Thread Radim Klasek
Hi i need advice I want to run my PHP script on Linux, but i want to use FoxPro database (.dbf) through ODBC. I didn't find such ODBC driver for Linux and i don't know how to connect with the script to the some machine with Windows system,where the data are stored and where ODBC is working. Can s