[PHP-DB] Oracle - Executing Stored QUERIES

2002-04-05 Thread Chris Andrew
Hi, Please tell me this is possible: I have a bunch of stored queries on an Oracle machine. Using PHP from a separate RedHat box, I want to run these stored queries. My PHP is compiled with oracle support, and I can issue regular SQL to the Oracle box - such as "SELECT foo FROM bar". This works

[PHP-DB] Oracle INSERT

2002-03-28 Thread Chris Andrew
Hi, This is probably more of a topic for the Oracle groups - however: This gives me an error: $c1 = ocilogon("chris","chris01"); $sql = "INSERT INTO tblTest VALUES(1,'Test One'),(2,'Test Two')"; $stat= ociparse($c1,$sql); It would appear my INSERT syntax is illegal under Oracle. Qu: How can I

[PHP-DB] PHP/MySQL to M$ Access

2001-11-15 Thread Chris Andrew
Hi, Until we completely migrate an application from M$ Access to PHP/MySQL, I need to figure out a way to temporarily query an Access DB from PHP/MySQL. I am aware of this article on PHP Builder: http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 which discusses using ODBC Socket Ser

RE: [PHP-DB] Select where

2001-03-20 Thread Chris Andrew
Tim, Your missing a double quotation prior to your SELECT. Further, are you connected to a database? : $result=mysql_query($sql,$db); Chris > -Original Message- > From: boclair [mailto:[EMAIL PROTECTED]] > Sent: 20 March 2001 14:54 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Select

RE: [PHP-DB] Whence Cometh Line Break?

2001-03-09 Thread Chris Andrew
Rather than use =, have you tried echo value="" Chris > -Original Message- > From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] > Sent: 09 March 2001 14:03 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Whence Cometh Line Break? > > > I've discovered that this little bit of code is introd

[PHP-DB] Updating a Grid of Data

2001-02-26 Thread Chris Andrew
My Setup: MySQL and PHP4. Two tables with one to many relationship: tblAccount (AccountId, AccountName, Comment) tblRates (RateId,GrossRate,AER,NetRate,AccountId(foreign key)). There are many rates per account. I need to provide a means for a user to loop through each element in tblRates updatin

RE: [PHP-DB] while loop driving me crazy

2001-02-21 Thread Chris Andrew
Remove the semi-colon after your while() statement. > -Original Message- > From: Miles Thompson [mailto:[EMAIL PROTECTED]] > Sent: 21 February 2001 15:01 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] while loop driving me crazy > > > I've used a similar structure hundreds of times, but th

RE: [PHP-DB] foreign key problem

2001-01-31 Thread Chris Andrew
A foreign key value can be null, if it suits the data application - or that is what I've always been taught. Here is a text book definition of Referential Integrity which was spoon fed to me by the Open University when studying their RDBMS course: "Referential Integrity - If a relation (table),

RE: [PHP-DB] LDAP

2001-01-24 Thread Chris Andrew
Hi Thomas, You are correct. You need to install ldap (openldap) prior to your PHP install. Don't forget to install the ldap development files if you're installing from rpm's. Then, when you configure your PHP: /configure --with-ldap= ... Chris > -Original Message- > From: Tom [mailto:[