[Greebo]

Need some help from some clever boffins.

At my university there is a tradition in place known as academic familes - where 3rd years adopt 1st years (in theory, but in practise anyone from 3rd onwards basically can adopt anyone) as their sons and daughters.
Due to the way this works, however, it can frequently be that one can end up in a situation where people end up being their own grandmother or something ridiculous like that.

Attempts to work out the family trees of even a small group of people tend to end up so sprawled that they frequently end up taking up the floor space of an entire room.

So what I want to do is create an online database family tree thing whereby people enter their details plus relatives details etc etc and eventually and hopefully the academic family tree of the entire university will emerge.

I've been looking at sql as a database tool and it seems easy enough - but what I haven't found is a bloody tutorial on how to link it into html pages.

Anyone got any handy links? (or advise - if you think sql is a pile of piss)
_________________
Most evil admin around.
Offical Ville songwriter.
"Captain Smart Ass"

[Jfet Zener]

http://www.w3schools.com/sql/default.asp is a good resource. i use it when i forget exact syntax or whatnot. seems, though, the first thing you would need to do is layout the databast. how many tables would you need? what info would be in here, what columns would this info relate to? how would it be set up so that loops dont take place (i.e. you try to show the family of A but A's dad is B and B's dad is A .... A is his own grandpa, as you said). once you have the tables designed, then i think its much easier to put into a database.

as for showing the info in html pages, you would need some sort of server side scripting. if it is running on a windows box, ASP would be the way. if *nix box, then php would probably be easiest.

ASP+SQL tutorial: http://www.aspwebpro.com/tutorials.asp (mainly the Display Data From Database page)

PHP+SQL tutorial: http://sandwil.beigetower.org/PHPsqlCourse/index.php seems to have alot of info about both individualle, and combines them around chapter 14.

[Stevo]

Well PHP is fairly easy to use to show SQL data on a webpage. You can PM me for more info if you want to use PHP.
_________________

The Official TVR Website
Fopp
Song of the Week

[Greebo]

Cheers guys - specially for the links - got some reading to do it seems (never used php before).

This is a looooong term project for me - I'll do it in spare time as and when I feel like it. But I'll come calling for help if I need it again.
_________________
Most evil admin around.
Offical Ville songwriter.
"Captain Smart Ass"

[Jfet Zener]

feel free to PM or IM me. been doing web coding (in PHP and ASP) for at least 4 years. cant remember much before that.