Search Engine To Search A MS Access Database With MP3 Data

Author	Thread
Search Engine To Search A MS Access Database With MP3 Data
Posted in tutorial: An ASP Tutorial to create your own Database driven Search Engine
· alien_creep Joined: 28 Jul 2004 Total Posts: 1	Search Engine To Search A MS Access Database With MP3 Data Posted: 28 Jul 2004 i am trying to make a search engine that will search the database for mp3 info. i want to make it possible so that if a songname, trackno or artist is entered, it will browse through the database by search enquiry and the results returned will be artist, songname, track no, tag id. etc. As i am a newbie to ASP, any ideas would be appreciated in trying to get this to happen.
· thebigdino Joined: 2 Nov 2004 Total Posts: 1	This is how you do it Posted: 2 Nov 2004 Use the like function to search the database, here is an example: strsql= "Select * from Tbltable where blaa like '%Mp3%'" blaa is whatever the column your table has and what ever you want to search.