I am setting up a music info site and have decided on the follow tables ( not to sure weather to add the mp3 part). The one main question I have before starting to make the tables is weather mysql_insert_id() would be able to handle this with the way I have it ? :Artist id artist_name
:Album id - auto-inc artist_id album_name rec_id image_id :Songs id - auto-inc album_id genre_id mp3_id lyrics :Genre id - auto-inc genre :Recording id - auto-inc recording_studio date :Album Image id - auto-inc image :Artist Info id - auto-inc info :Mp3 id - auto-inc mp3_location Any other suggestions are welcome. B.J.Rumsey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
