Re: [PHP-DB] properly a simple question

2002-01-13 Thread Miles Thompson
Barry, You're 3/4 of the way there. You understand how data is normalized, and you have the proper keys so that you can link your tables in a multi-table join. For specific syntax you should check the MySQL manual, but what you want is roughly this ..and I'll make up some field names. (Becaus

Re: [PHP-DB] properly a simple question

2002-01-13 Thread DL Neil
Barry, This is properly a simple question but I can't figure it out. =please don't ask im-proper questions, this is a family environment!!! Lets say I've got there tables: table1(art_id,artist), table2(song_id,art_id,song), table3(image_id,art_id,image). What I'm trying to do is get 1 image dis