[williamscel]

fellow coder,
i have a database that has been linked to a vb interface. the buttons work. the problem im having is when i click on the 'artist' button i get all the songs and artist in the database. what i want is when i click on a button for assigned to a particular artist only songs by that artist come up. im not sure if a sql statement will solve this. if so how do i do it.

[JackOfAllTrades]

select * from table_name where artist_name_column_name = "artist_name"

[williamscel]

williamscel, on 01 March 2010 - 01:02 PM, said:

fellow coder,
i have a database that has been linked to a vb interface. the buttons work. the problem im having is when i click on the 'artist' button i get all the songs and artist in the database. what i want is when i click on a button for assigned to a particular artist only songs by that artist come up. im not sure if a sql statement will solve this. if so how do i do it.

thanks.
i seem to be having some problems still. i have buttons that go previous and next through artists and another button to select songs. what i want is for example. if i go to beegees and select the button thats says songs i want only songs by beegees to come up from the database and then if i click next and usher comes up and i click songs i want only songs for usher to come up. i know what i want but just not sure how to do it.