IDE advantages: most compatible with desktop pcs, inexpensive
IDE disadvantages: slowest, large cables, not recommended if running a server or multiple apps that tax the drive, shorter warranty than scsi (1-3 years)
SATA advantages: WD Raptor (10k rpm drive) only available w/SATA interface, this is arguably the fastest drive most users will need. There are currently no inherent advantage to SATA drives over IDE aside from thinner cables.
SATA disadvantages: Requires SATA controller, drives other than the Raptor are still considered "slow" compared to SCSI. The controller is becoming more and more common on motherboards, so compatibility is becoming less of an issue, warranty on all drives other than the Raptor is less than 5 years, not recommended if running a server or multiple apps that tax the drive
SCSI advantages: ultimately the fastest setup, ideal when more than one processes taxes the drive, supports the most drives, longer cables, hot swapping (with appropriate hardware) and best reliability (5 year warranty on all drives)
SCSI disadvantages: much more expensive than IDE or SATA for the same amount of space. Controller is rarely built into motherboards, cables are thicker than SATA
This is just the tip of the iceberg, as threads discussing harddrives and their merits can sometimes extend a few pages. :Q It should give you an idea as to what might fit your needs best.