> 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 dat
> 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
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
>
>personToPersonRelations
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
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
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 directo
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 a
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
I was able to access my database for weeks and now I am getting this error.
Can anyone help?
Warning: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) in
/home/blah/public_html/includes/configi.inc.php on line 3
Warning: MySQL Connection Failed: Can't connect to
> 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 esp
Does anyone see anything I might be missing as to why this won't work?
From the file calling the function:
$round = "Round 1";
$region = "East";
include "check.php";
isAuthorized($_COOKIE['username'], $_COOKIE['password']);
include "checkEntry.php";
check4Entry($username, $round, $region);
...
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 especi
Hi to all,
I posted this question before, but I don't know if guys got it. If you did,
I'm sorry.
I just installed PHP 4.3.1 on a windows 2000 machine. Everything works fine
except for graphics. I can't generate graphics. I copy the php.ini to
C:\WINNT\system and uncommented the line for php_gd.dl
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
f
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 selec
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 wri
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
"War
17 matches
Mail list logo