Linked Database fed Drop Down Boxes

[neiltaylormade]

Hi All,

 

I know this is a common question but I just cant find the answer that suits me. I have a database with 2 tables, one named galAlbums and the other galImages. Basically all I was to do is have two drop down boxes the 1st with the album names, stored in galAlbums, and the second with the image names stored in galImages. each album has a unique id (albumID) and the select box will uses this as the value, but the label will be the album name (albumName). I then want the next dropdown box to be populated with the images in that album but WITHOUT a page refresh. the images have a unique id (imageID) a name (imageName) and also they are linked to the album in the field imageAlbum, which the number relating to the album in galAlbums. I am assuming the best way of doing this is by using ajax, but I have searched the internet twice over and cant find the answer anywhere.

 

Any help will be appreciated.

 

Thanks

 

Neil