Halfsibling - same mother????
Posted: Fri Jul 28, 2006 8:03 am
Everah | Please use
Can some one help me with a script for displaying halfsiblings - same mother??
Thanks for the help.
Everah | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi,
I am trying to build a database (and that works fine) but i want to have an output when i ask for excample "Halfsibling - same mother:"
details of the database:
[syntax="sql"]CREATE TABLE `dog_table` (
`Id` int(11) NOT NULL auto_increment,
`DogRegis` varchar(30) default NULL,
`DogName` varchar(50) default NULL,
`DogTitle` varchar(60) default NULL,
`Callname` varchar(20) default NULL,
`DOB` date default NULL,
`DOD` date default NULL,
`Gender` varchar(20) default NULL,
`Color` varchar(20) default NULL,
`FatherId` int(11) default NULL,
`MotherId` int(11) default NULL,
`WrightCoef` varchar(20) default NULL,
`CountryOrig` varchar(20) default NULL,
`Kennel` varchar(20) default NULL,
`Breeder` varchar(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `DGPrimRegNbr` (`DogRegis`,`DogName`)
) ENGINE=MyISAMThanks for the help.
Everah | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]