[PHP-DB] using foreign keys in mysql

hello! could anyone help me out in how to link two tables in mysql on foreign keys or is there any other way to do this in order to check referential integerity. any +ve response would be appreciated. msjamal __ Get personalized email addresses

Re: [PHP-DB] db2 with php

I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into server: libdb2.so.1: cannot open shared object file: No such file or

[PHP-DB] Installation Problem

Hello, I downloaded the source of php 4.0.4pl1 and compiled it on RH7.0 with mysql server 3.23.32. The compilation was a success. However, the httpd wouldnt start. It says: cannot load libphp4.so: undefined symbol: gss_mech_krb5 I assume that it was the kerberos problem, so I recompiled it with

[PHP-DB] Pbs with Oracle

Hi everybody, Still with the same configuration (Apache1.3.14 + PHP4.04pl1 + support for Oracle 8.0.5 with OCI, all on HP-UX 11), I manage to connect to my base (ocilogon, ociparse and ociexecute). After that, whenever I try to get the results, it prints well the column name but not the data. I

[PHP-DB] PHP-Authenticate (again!)

Hi... I have a problem with PHP Authenticate ...if I enter user/pw wrong the first time it stops and I have to close/open browser.! I've tried to unset $PHP_AUTH_USER but then it just loops... if(!isset($PHP_AUTH_USER)) { Header("WWW-Authenticate: Basic realm=\".: Privat område :.\"");

Re: [PHP-DB] mysql to pgsql

create table foobar (todaysdate datetime default now()); jeff On Sun, 4 Feb 2001, phobo wrote: Never used pgsql; but try DEFAULT NOW() NOT NULL ?? Siggy - Original Message - From: "Cameron" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 04, 2001 5:18 AM

[PHP-DB] Make good money online! It's easy ....

Please see the bottom of the message for the remove instuctions. What you are about to read is tried, true, proven and effective. Above all, this offer is utterly and ridicously excellent!! Have you ever tried or considered making money using the internet? Are you marketing or promoting

Re: [PHP-DB] Copy table to file inside PHP

What is the error you get? To do the Copy you need to specify a userid in your pg_connect like $conn = pg_connect ("host=localhost port=5432 user=userid dbname=dbname"); That should take care of it. It did for me! At 12:02 AM 2/6/01 +0900, Achmad Gutomo wrote: Hi PHP Gurus ! Anyone have idea

Re: [PHP-DB] Copy table to file inside PHP

The userid needs to be your DB Super User (ie allowed to create db's) At 11:15 AM 2/5/01 -0500, Brian C. Doyle wrote: What is the error you get? To do the Copy you need to specify a userid in your pg_connect like $conn = pg_connect ("host=localhost port=5432 user=userid dbname=dbname"); That

[PHP-DB] Re: [PHP] Lowercase problem

Try quoting your table names. SELECT * FROM "WHATEVER"; -Mitch - Original Message - From: "Julio Cuz, Jr." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 05, 2001 12:25 PM Subject: [PHP] Lowercase problem Hi-- I don't know where the problem

[PHP-DB] --with-Oracle caused apache to not load

If I compile php using --with-oracle and --with-apxs and try to load that module apache seg faults on loadup. Compiling php without oracle works fine. Compiling php with oracle and as a CGI works fine. I'm running Oracle 8.1.5, php4.0.4pl1 and apache 1.3.14 under RH6.2 Any ideas? Mark --

Re: [PHP-DB] using foreign keys in mysql

the current production rev of mySQL does not support foreign keys. so, you have to implement it in your application logic. i think they are working on foriegn key support for a future release, but i am not sure. -lucas On Mon, 5 Feb 2001, sajid jamal wrote: hello! could anyone help me out in

Re: [PHP-DB] Quickie Question

First, check your indexes.. second, check your queries on your display list to make sure you are only selecting data that is needed. I recently ran across a problem where queries on a long list were taking forever to execute. I was selecting * from the table thinking that I was using all the data

[PHP-DB] php to mysql probs.

I'm using PHP (v4.0.4) as a web front end for a MySQL (v3.23.29) database running on Windows 2000 machine. The problem is that I am relatively new (I've been messing with this for only a month) to this and don't really know where to look for information on the connection problems-- the web

Re: [PHP-DB] How to set up PHP to access Oracle

On Mon, 5 Feb 2001, Doug Schasteen wrote: Fatal error: Call to undefined function: ora_logon() Obviously my server is not set up to use Oracle. Oracle is not installed on this machine. I am trying to access a different machine that has oracle installed. So what steps do I have to take to

Re: [PHP-DB] RESEND - php class to C struct interface possible?

Maybe if you build a PHP module... info available at zend.com --Toby Phil Rhoades wrote: Hi all, Thought I would try sending this again - didn't get a reply last time - guess I'll give up if this attempt doesn't get a reply . . I've just subscribed and haven't even got any mail from