BHB

I was curious about spl.

Thanks! I was leaning that direction. This is just for home server convenience.

Avatar is a carriage horse. So I am behind but up high enough to see across his back. I am a horseman and artist. Have not been programming for long. I will study this. Maybe my problem has been in presenting a correctly formatted array. Array must be two dimensional, correct? Using SPL to get file name and file size. Just my first time using these functions. I have stuck to procedural code to date though i have been reading oop. Knowing it is possible helps a lot!!! Thank you. I will post some code if I get super stuck.

I am writing a little script to read files in a folder (photos) returning an array of file name and file size. Can mysqli handle a prepared statement inserting an array? Would be nice to insert 500 photo names at once rather than typing them all in. Ps.. Not for a public site, just a script i run on a home server to build a site. Tx

Function get XML,... Got it

Can you have all data in one domain and own say 30 domains that relate then feed each domain different subset of data to build complete different sites? I assume yes. Suggest a book??

Well thank you, I understand. I would like to further understand this books chapter. Maybe then i will better understand your method. Anyone willing to attempt helping me on the books method??

Good gracious! This is way over my head. I am in kindergarten code I guess. I don't see me writing this amount of code to produce pedigrees,.. The depth of these queries is unbelievable! I am just starting with stored procedures. This method is a bit familiar; I think I had come across it before. I am only 18 months self taught in my spare time. Makes the self join loop in Larry's task example look so simple. You have not use recursive functions? You want me to learn this, I think you should make a recursive function!!! In jest,. you must be a genius and it would only take you 10 minutes. What about CSS? Do you have design in your bag of tricks?

Hmmm, hartley-how do you auto fill left and right position for tree? This must be entered by hand or an algorithm? I am not very patient am I?

Ok, reading this. Being my experience level I can not argue approach. Right off I am seeing that this returns position (design). I want to be able to produce CSS div tags. Will I be able to with this method? This is mandatory for me. I wish I had 12 hour days to study and learn everything out there but I only get a couple hours/ day. Another important criteria is to produce XML. You must understand if I want to produce information to 100, 800 domains on many servers i have only one method to do this that makes me feel as a business owner will satisfy producing my product. XML data. I have to this point really only learned Larry Language. I can wrap my brain around other but will take me some time to get it. I ask these questions ahead (divs and XML ) so I know I am climbing the right tree!! Ha ha ha!! If nothing else it will help me learn to think outside my box. I still must learn this chapter in Larry's book as well. It is not ok with me to hit a dead end when I set out to learn something. Correct method or not, these are most worn pages in any of my books. So back to page 19-20? That function I wrote will go up single line of sireid right? Makes me think I must encorporate the damid into single function. Array with just three id should be iterated each to three id each,.. I can call the names after id are found with a stop. Array(horseid, sireid, damid) Reading entire links now Hartley,..

I can see entering 100 horses a day easy, maybe more. So the reorder each time a record is added sounds scary.

hmmm, much to digest. I guess I don't understand why I would separate the tables. would I not take chance of duplicate entries for sire/dam? It takes time for me to absorb, so my initial reaction is just confusion. descendants as a word to me means top down, not bottom up. Here is some data. Not that I have entered enough to get really good charts yet. Most is sire => 1 and dam=> 2. I can add more flushed out pedigrees is that helps. Array ( [horse_id] => 1 [horse_name] => Unknown Stallion [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 2 [horse_name] => Unknown Mare [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 3 [horse_name] => CHINN [sire_id] => 1 [dam_id] => 15 ) Array ( [horse_id] => 4 [horse_name] => R-Saluut II [sire_id] => 1 [dam_id] => 1 ) Array ( [horse_id] => 5 [horse_name] => C-Picasso [sire_id] => 3 [dam_id] => 2 ) Array ( [horse_id] => 6 [horse_name] => BROADWAY boogie-woogie [sire_id] => 1 [dam_id] => 15 ) Array ( [horse_id] => 7 [horse_name] => Captain America [sire_id] => 6 [dam_id] => 2 ) Array ( [horse_id] => 8 [horse_name] => R-Flash Gordon [sire_id] => 4 [dam_id] => 2 ) Array ( [horse_id] => 9 [horse_name] => Destiny [sire_id] => 4 [dam_id] => 20 ) Array ( [horse_id] => 10 [horse_name] => Biscotti [sire_id] => 4 [dam_id] => 14 ) Array ( [horse_id] => 11 [horse_name] => Berolina [sire_id] => 5 [dam_id] => 2 ) Array ( [horse_id] => 12 [horse_name] => Byacinthe II [sire_id] => 4 [dam_id] => 2 ) Array ( [horse_id] => 13 [horse_name] => American Girl [sire_id] => 4 [dam_id] => 14 ) Array ( [horse_id] => 14 [horse_name] => Pristine [sire_id] => 3 [dam_id] => 2 ) Array ( [horse_id] => 15 [horse_name] => Frascatti [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 16 [horse_name] => Zu Zu [sire_id] => 5 [dam_id] => 2 ) Array ( [horse_id] => 17 [horse_name] => La Bella [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 18 [horse_name] => VicTaurus [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 19 [horse_name] => Olivia [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 20 [horse_name] => October Secret [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 21 [horse_name] => White Shoulders [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 22 [horse_name] => Daisy [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 23 [horse_name] => Farlapp [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 24 [horse_name] => cZur [sire_id] => 3 [dam_id] => 2 ) Array ( [horse_id] => 25 [horse_name] => Belle [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 26 [horse_name] => Lydia [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 27 [horse_name] => Limbo [sire_id] => 1 [dam_id] => 2 ) Array ( [horse_id] => 28 [horse_name] => Royal Prospect [sire_id] => 1 [dam_id] => 2 )

While getting file, here is a link of an old page. Pedigree does not link, static text probably in a table. http://cloverlone.com/Broadway.htm

Ok Antonio. I will fire up the computer. Give me a minute.

I don't see the connection on that link. The id in my database is not because of position, it is an autoid in a list of maybe thousands of horses. I can see that position will need a number but example has position being the id. First horse queried based on variable sent to form. Then query should retrieve fatherid as an array(id, name, fatherid, motherid), motherid as an array (id, name, fatherid, motherid), etc. trick is in writing a function to shorten long worded query.... It is long. I got to second grandmother and knew was best to abort and get function to do work. Maybe I want a six generation pedigree link instead of three. That would be insane code. I will keep reading link see if I can't translate the info into what I need.