Rate my Pet??

I have a tiny ember of an idea for a site, unfortunatly it seems that its going to require some pretty hefty database's to drive it.

I'm sure youve all seen those "ratemypet" sites, where people can upload pictures of themselves or their pets and have other people rate them, and in some instanes leave comments etc on said "pets".

I was wondering if Php / My sql would be the prefered route for acheiving this? And possibly an indication of how difficult it may be to acheive.

All suggestions appreciated

You could try chucking a bucket of water over your tiny ember before it catches fire completely.

Not sure exactly what you mean, i realise this sort of thing is done an awfull lot, myspace etc..... i was just wondering how difficult it was to acheive?

Its realy easy with php and mysql. A user just creates an entry in a table and then you need a simple rating system

thats what i figured ..... however, the ones ive seen are generally extremely badly done, and are missing much of the functionality that i would like to see in these type of sites.

take myspace for example.... its horrible

this is a design issue i suppose, but is there any real reason why this type of site tends to look like the attrocity from the black lagoon, or is it just lack of design ability on the part of the creators?

Opinions obviously rather than fact on this one

having made an entire cms for my website in php mysql i realized there is a huge difference in the way you design your tables.

an example of a bad table:
Users:
Cols:
username, password, pic1,pic2,pic3,pic4pic5,pic6
this is a hassle and limits the person to 6 pics. it also makes programming easy and lazy, forms turn into a list.

a better method would be:
pictures:
owner, type, pic

then you would have a control panel type form for it, that shows what images the person has up and alows them to add as many as they have.

__________________
www.MonsterCoding.com - Website Programming and Development Services

yeah, ive allways been told that you should use seperate tables for each item in your database.

So, 1 table for you members, passwords & personal information

&

Another table for your member inputted content, profiles & the links to there pictures.

Is this what you were driving at?

7/10

what a beutifully elusive post Dan, are you having a minor psychiatric episode? ... or is that meant to mean something?


edit ::: Must be loosing my mind in retrospect......... it was meant to be funny.... and if im tottally honest, now that ive worked it out im mildly wetting myself with chuckles..

ill leave the origional post above, because ii like the idea of moderators having psychatric episodes.... it makes me feel human

i never have minor psychiatric episodes!! Major ones maybe, but not minor ones!