[ic] pedigree database

[localhost]

Hi,

I wanted to build a dog pedigree database, and I was wondering the best 
way to handle building the results page.

so far my test site is at:
http://www.amselravenwood.com/cgi/avr/scan/mp=shepards.html

you can click ont the dog names to see the pedigree info.

I am using a mysql database, and I wanted to know the best way to pull 
the data for the "grandparents"

this is the code to find the "father" of a dog:
---------------------
<!--Father -->
[search-list]
[if data dogs::sire::[item-data dogs code]]
[query sql="SELECT registered_name FROM dogs WHERE registration_num = 
'[item-data dogs sire]'"
type=list]
[on_match]
  > [list][sql-code][/list]
[/on_match]
[no_match]no match[/no_match]
[/query]
[else]data missing[/else]
[/if]
[/search-list]
--------------------

Also, the "no-match" is not working. there is always a match if the 
first "if" passes.

Anybody have any ideas?

Thanks
Rick