Re: [PHP-DB] php.ini

> i found that even i have not the php.ini in my SYSTEMROOT, php can still > > run ... why? > > Sometimes they place it in C:\winnt\php.ini search for php.ini and it will show if there is a file and where it is. Russell Griechen -- PHP Database Mailing List (http://w

[PHP-DB] Normalize ...relationships

a table 'hound' contains ownerID, breederID. These both are to be normalized in a separate table as in: CREATE TABLE sportsmen ( sportsmenID bigint (10)notnull autoincrement, Question: How? based on a sportsman can be a owner, breeder, hunter, President, Senator, Governor etc; CREATE TABLE hound

[PHP-DB] Exploding Nodes Recursively

Explode all folders to all levels? A exploding nodes... A drop down lets user select number of generations and the execution shows the trees being populated... I have been trying to find the code to execute this MySql table Dogs: ID AutoNumber Primary Key RegName Text Sex Yes/No Dame Long Int Ind

[PHP-DB] php includes for templates

Daniel Cardenas graciously offered the script but I can not develop the right syntax. see code at: http://sportsmenafield.com/index.txt Russell Griechen...trying to escape frames to a php include template. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Re: file upload and php (Not a begginer [sic]question!)

you want uploaded and it will create any folders needed and fill or overwite any directories or files. Russell Griechen - Original Message - From: "Paul Burney" <[EMAIL PROTECTED]> > > > I'm looking for a tool or script that could work like a direct ftp br

[PHP-DB] PMA Database ... not OK[ Documentation ]

E privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser): GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost'; do not give any other user rights on this da

[PHP-DB] Php-Beautify

This program says: Extract the files and put them in a directory, where they can be executed by PHP. My Php is in C:\Program Fileswhere should I extract these files to? Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pedigree question

a storage space at the expense of data processing > power creating the joins on the fly every time I needed them. > > Just a thought... > > Matt > > P.S. If anyone sees any "evil" inherent in my design I'd love to know... This is an interesting idea, The spouse c

Re: [PHP-DB] Pedigree question

original post below. Russell Griechen htttp://sportsmenafield.com > On Sun, 6 Oct 2002, Russell Griechen wrote: > > > I need to develop a tree-like pedigree of animals up to 5 generations. > > I know there are other attributes to the animal; but do I need anyother > > tables..

[PHP-DB] Pedigree question

neat 5 generation tree. Is there any other alternatives? Animal ID Name Foal ID SireID DamID Russell Griechen htttp://sportsmenafield.com Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Is this a transposition

user_stage_map ; create table user_stage_map ( user_id integer not null, stage_id integer not null, primary key user_stage_map_key (user_id,stage_id ), key stage_user_map_key (stage_id) ); Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Noob questions...

Try this http://www.mydomain.com/phpmyadmin/ and be ready with your password. Russell Griechen > You should ask if your ISP has not already installed a phpMyAdmin that you > can use - save you the bother. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, vi

[PHP-DB] PhpHoo_create database phpHoo\p\g

auto_increment, CatName varchar(32) NOT NULL, CatParent bigint(21), PRIMARY KEY (CatID), UNIQUE (CatName) )\p\g Russell Griechen htttp://sportsmenafield.com Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] table naming issues

Does anyone have any table-naming systems to keep tables grouped so that they will be more readily available in PhpMyAdmin's left column? maybe 001_contacts and 002_users for large databases supporting a CMS Russell Griechen htttp://sportsmenafield.com -- PHP Database Mailing

[PHP-DB] Create database phpHoo\p\g

auto_increment, CatName varchar(32) NOT NULL, CatParent bigint(21), PRIMARY KEY (CatID), UNIQUE (CatName) )\p\g Russell Griechen htttp://sportsmenafield.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Breeders database

;parent' # DROP TABLE IF EXISTS parent; CREATE TABLE parent ( id bigint(21) NOT NULL auto_increment, sireid bigint(21) DEFAULT '0' NOT NULL, damid bigint(21) DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); # # Dumping data for table 'parent' # Russell Griec

[PHP-DB] PhpMyAdmin's File Manager and apps

Where are the downloads for these apps? Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Configuring www.phpmyadmin/config.inc.php

// with 'config' auth_type) $cfgServers[$i]['only_db'] = 'database_name'; // If set to a db-name, only // this db is displayed

[PHP-DB] Create database

e created successfully\n"); } else { printf ("Error creating database: %s\n", mysql_error ()); } /*error Error MySQL said: You have an error in your SQL syntax near '$link = mysql_pconnect(\"64.177.44.120\", \"russgri\", \"sportsme

Re: [PHP-DB] Error creating new table

>You can't have NOT NULL assigned to a text field. So...should it be maintext text NULL, or just maintext text ??? Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Contact Database php_mysql

> -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php So reflecting what advice I have received to date: [Sportsmen] name to be registered of www ContactID FirstN,MidN,LastN,Suffix,Cityid,Stateid,Zip_Codepk,Addr1,Addr2,Other Cityid pk CityName Stateid pk Statename Assnid Assn (Associations) Trials/Showsid Trials/Show Houndsid Registry# /*Date to be a Timestamp?...reflecting mmdd001 to infinity refecting how many hounds born on that date*/ IFSB# SFSB# UKC# AKC# Whelping Date /*Is there such a thing as Dateid (linking table)*/ Sire (houndid) Dam (houndid) Owner (contactid) Breeder (contactid) Colorid (20+ color combinations) /*I have developed a CSS file that will display hound names in a heirarchial display to display a pedigree. My hope is to be able to use only the Sireid and Damid to present 5 generations???*/ Thanks for the advice So reflecting what advice I have received to date: Assuming that the Contact table would be used for: Owners, Breeders, Sportsmen, Ancestors, Associations, and a myriad of other categories of mankind, would the following normalization be prudent? ContactID FirstN,MidN,LastN,Suffix,Cityid,Stateid,Zip_Code_pk,Addr1,Addr2,Other Cityid pk CityName /*?? What about Norwood, MO...Norwood, MA*/ Stateid pk Statename Assnid Assn (Associations) Trials/Showsid Trials/Show Houndsid Hound Name Registry# /*Date to be a Timestamp?...reflecting mmdd001 to infinity refecting how many hounds born on that date*/ IFSB# SFSB# UKC# AKC# Whelping Date /*Is there such a thing as Dateid (linking table) ?*/ Sire (houndid) Dam (houndid) Owner (contactid) Breeder (contactid) Colorid (20+ color combinations) Colorid Colorname Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Contact Database php_mysql

ent 5 generations???*/ /*I will have a large server thus excess capacity, php, mysql, pop3, mailing lists...maybe I can reward some of my helpers down the road*/ Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Contact Database php_mysql

, Address_1,Address_2, [City] id Cityname id (al, ar etc) Statename [ZipCode] id Zip_Code Comment please, Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php