[PHP-DB] Apache, PHP+Informix on Windows NT 4.0 Server - memory allocation

2003-03-17 Thread Brzeziski Mariusz
Hello! I run Apache in 1.3.22 version, PHP 4.3.1 with Informix module. I have it on two machines: a) Windows NT 4.0 Workstation + SP 6.0 b) Windows NT 4.0 Server + SP 6.0 The same PHP scripts on a) it works perfectly, but on b) when I try to connect to Informix server (on Unix SCO) I got

[PHP-DB] mysql_connect() problem

2003-03-17 Thread Indrajit Paul
Hi, I am using Apache 2 in Linux 8 .Whenever in my php script I want to connect to mysql through mysql_connect() function a error occured. My script is like that $linlid=mysql_connect(localhost,user1,user1)or die(Connections failed); print Connected successfully; The script writes

Re: [PHP-DB] Performance in MySQL Result Question

2003-03-17 Thread Brent Baisley
I know what you are trying to get at. A full select and a select with limit have the same query speed, but the full select has to transfer all of the selected data, where as a limit only transfers the number of records specified. The more records that match a search, the faster your limit

Re: [PHP-DB] mysql_connect() problem

2003-03-17 Thread David Smith
You need to install the php-mysql rpm. You can get this on your RedHat CD, or through apt-get: apt-get install php-mysql Get apt here: http://apt.freshrpms.net/ Does the PHP project ever plan to do something as impressive as CPAN so users won't have to reinstall or recompile just to extend its

[PHP-DB] several pointers to records in one field

2003-03-17 Thread Alain Barthélemy
Hello, I started to use PHP with MySQL last december. Personal use: list of inhabitants of a town in the 15th century Problem is the following: one person has an arbitrary number of children. It is heavy to have fields child1,child2,child3,...,childn containing the row number of each child

[PHP-DB] User Defined Function Problem

2003-03-17 Thread The Cossins Fam
Does anyone see anything I might be missing as to why this won't work? From the file calling the function: ?php $round = Round 1; $region = East; include check.php; isAuthorized($_COOKIE['username'], $_COOKIE['password']); include checkEntry.php; check4Entry($username, $round, $region); ...

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread CPT John W. Holmes
I started to use PHP with MySQL last december. Personal use: list of inhabitants of a town in the 15th century Problem is the following: one person has an arbitrary number of children. It is heavy to have fields child1,child2,child3,...,childn containing the row number of each child

RE: [PHP-DB] Server Error

2003-03-17 Thread Luke Woollard
Your MySQL Database is down. 'cd' to your mysql directory (probably /usr/local/mysql ) and type ./bin/safe_mysqld --user=mysql -Original Message- From: Marie Osypian [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 March 2003 8:42 AM To: php-db Subject: [PHP-DB] Server Error I was able

Re: [PHP-DB] Server Error

2003-03-17 Thread Peter Beckman
Does /var/lib/mysql/mysql.sock exist? Is it world unwritable? Is it writable by whatever user starts mysql? Does it exist (did it get deleted)? Are you sure you want to use configi.inc.php and not config.inc.php? That's all I can think of. On Mon, 17 Mar 2003, Marie Osypian wrote: I was

RE: [PHP-DB] Server Error

2003-03-17 Thread Luke Woollard
This should read 'Your MySQL Database SERVER is down' Thanks, LW -Original Message- From: Luke Woollard [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 March 2003 8:48 AM To: Marie Osypian; php-db Subject: RE: [PHP-DB] Server Error Your MySQL Database is down. 'cd' to your mysql

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread Alain Barthélemy
Le lundi 17 mars 2003, 16:12:32 ou environ CPT John W. Holmes [EMAIL PROTECTED] a écrit: I started to use PHP with MySQL last december. Personal use: list of inhabitants of a town in the 15th century Problem is the following: one person has an arbitrary number of children. It is heavy

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread Alain Barthélemy
Le lundi 17 mars 2003, 22:04:08 ou environ Ignatius Reilly [EMAIL PROTECTED] a écrit: The standard relational way is a relationship table: children - FK_parentID (parent) FK_childrenID (child) PRIMARY KEY ( FK_parentID, FK_childrenID ) HTH I started to use PHP with MySQL

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread Alain Barthélemy
Le lundi 17 mars 2003, 15:19:07 ou environ May, Patrick [EMAIL PROTECTED] a écrit: The table structure I can imagine: person personId name etc relationship relationshipId description personToPersonRelationship

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread CPT John W. Holmes
Thank You. Tell me if I misunderstood or if I did not express me clearly. Sounds like you got it! :) You may also want to read up on nested sets for your database structure. They work the parent_id and child_id differently and it may make queries easier for your situation. For instance, with

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread CPT John W. Holmes
Here's one explanation... search for others: http://threebit.net/tutorials/nestedset/tutorial1.html#t Here's the example I was looking for... it took me a while to find it: http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html It's good reading for anyone working with