Dog Pedigree

Mary,
I think you can create table with all grandDads and grandMothers using ViewOnLoad event on the Events tab.

Publish your project to the Demo Account, post link to your pages here and I'll try to help you.

Hi Jane: just wanted you to know that I am trying to upload to demo but having problems. I hope it will be there soon. Thanks so much!

Mary,

Mary,

Hi Jane: is this what you need?
http://demo.asprunner.net/brookhill_hughes.../labs/login.php
Thanks!!!

Hi Jane: I belong to a forum that is run by a gentleman that writes books for php and mysql. This is the recommendation given by one of the other members with a note from the author of books that it is exactly what he would do:
>>>>>>>>

$sql = "SELECT RegName, SireID, DamID FROM pedigrees WHERE ID=$ID";

$result = mysql_query ($sql);
if ($result) {
// start an html table

echo "<table>";
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

$dog = array ('RegName'=>$row['RegName'], 'SireID'=>$row['SireID'], 'DAM'=>$row['DamID']);
// get Sire info

$SireQ = "SELECT RegName, SireID, DamID FROM pedigrees WHERE ID={$row['SireID']}";

$SireR = mysql_query ($SireQ);
if ($SireR) {

$SireRow = mysql_fetch_array ($SireR, MYSQL_ASSOC);

$dog['Sire'] = $SireRow['RegName'];

$dog['GrandSireID'] = $SireRow['SireID'];

$dog['GrandDamID'] = $SireRow['DamID'];
// add additional queries for greatGrandSire and greatGrandDam
} else {

$dog['Sire'] = '';

$dog['GrandSireID'] = NULL;

$dog['GrandDamID'] = NULL;

} // end of $SireR conditional
// add additional queries for Dam sIDe of family (no pun intended)
// print row of results

echo "<tr><td>{$dog['RegName']}<table><tr><td>{$dog['Sire']}</td><td>{$dog['DAM']}</td></tr></table></td></tr>";
} // end of while
// close table

echo "</table>";
} // end of $result conditionalThis way, all of the dogs can be stored in one table, whether they are parents, grandparents or great-grandparents. Each will have (if you have the information) fields indicating which record in the table is related as a sire or dam. Since you are retrieving the same info whether they are a child, parent, grandparent, etc and only the WHERE clause is different, you could store the SELECT and FROM part of the query as a string, and concatenate the WHERE part at each step, to simplify it.

<<<<<<<<<<<<<<<<

Would you make it part of the 'view.htm' or the 'view.php' file?
Would you use 'Smarty' to generate the arrays? It is my understanding that he is suggesting multidimensional arrays.
Thanks!!

Hi Again! I meant to start this email with "do you think something like this would work?
If not, just ignore all my questions!!!! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=19805&image=1&table=forumreplies' class='bbcemoticon' alt='<<' />

Mary,
I recommend you use this code in the View Page: BeforeDisplay event on the Events tab. All values from the view page are stored on the $values array:

global $conn;

Mary,

Jane: thanks so much!!
I will give it a try!!

Hi Jane: I have been working on this and now it is to the point tht the view page actually opens and shows a table that I put on the bottom of it. Does this mean it's working and now I just have to get it to print properly into my table?
You can look at it here - www.fortheloveoflabradors.com/labradors/login.php by signing in as 'guest'.
If you have any ideas on getting it to print out, I sure would appreciate it. It's hard for me to figure out because if something doesn't work, I don't know if I make a typo or if the function isn't working. Thanks!!!!!!!

Mary,
I can't test your application because there is an error in your event.

Publish your project on the Demo Account and send URL to your pages to [email=support@xlinesoft.com]support@xlinesoft.com[/email]. I'll try to help you.

Mary,

Thanks Jane: I keep working on it but everytime I find and fix one problem, there's something else.

Mary,
You may find it easier to change your database structure, and have a dog table and a parent/litter table:
Dog Table

Fields: ID, RegName, RegNo, RegCountry, Gender, Title, Addl_Titles, Color, Owner, ParentID
Parent/Litter Table

Fields: ParentID, DamID, SireID, DOB, Breeder
DamID and SireID link back the ID in the Dog Table

ParentID in the Dog Table link to ParentID in the Parent Table
This has the following advantages:

• Information about the dog is only stored in one place - easier for searching on dog name etc
  
• If you are storing dog litters on your database, it makes it easier to link them together, and you only need to store the Dam and Sire once
  
• You are not limited by how many generations of dog you can store on your database
  Regards,
  Gordon

Mary,

• Information about the dog is only stored in one place - easier for searching on dog name etc
  
• If you are storing dog litters on your database, it makes it easier to link them together, and you only need to store the Dam and Sire once
  
• You are not limited by how many generations of dog you can store on your database
  Regards,
  Gordon

Thanks Gordon: I actually already have sire and dam tables. Do you have suggestions as to how to handle this with them?
Jane is I think working on it. Jane, what do you think?

Mary,
I think you can use your database structure or change it, but the code in the View page: Before process will be the similar.

You need to select all parents for the dog, place these values to the table and print this table on the view page.

Mary,

Thanks Jane: This is what we have been trying to do. The problem is that I do not know how to do it. As it is now, with the code currently uploaded to the demo site I do not appear to be getting any errors but it is not printing out the names. So, I am not sure if it is not working or just not printing out.
Right now what I would like to do verify that the code to obtain the ancestors is working and if it is not, fix it. If it is and when it is working, I need help in getting it to print out!!

Mary,

Ignore my last message as I just saw your email. Thanks!!!

OMY I cannot even believe it but my pedigree works!!! It grabs the correct info and LAYS IT OUT RIGHT - which I must say was no easy task!!!
However, I do have a snag. If the sire of the current dog is unknown I get an error message that says
'undefined variable' on the internet and 'variable used before it was identified' in another progam that checks syntax. I am certain that it is from this:
else {

$RegName == 'Unknown';

}
RegName is previously defined like this
//Get Sire(

if (is_numeric($row['SireID'])) {
$SireQ = $sql . $row['SireID'];

$SireR = mysql_query ($SireQ);
$SireRow = mysql_fetch_array ($SireR, MYSQL_ASSOC);

$SireRow = array (

'RegName' => $SireRow['RegName'],

'SireID' => $SireRow['SireID'],

'DamID' => $SireRow['DamID']);
Any advice? Thanks so much!!!!!

Mary,
try to check value before:

//Get Sire(

HURRAY!!! It works!!! I could never had done it without your help! Thanks so much to everyone who helped me get it going!!!