Current location: Hot Scripts Forums » Programming Languages » PHP » Making a searchable database


Making a searchable database

Reply
  #1 (permalink)  
Old 08-15-03, 11:04 AM
eddieweb12 eddieweb12 is offline
New Member
 
Join Date: Aug 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Making a searchable database

Hello. I am looking for a script (or some help on programming one myself) that will allow visitors to search for a MIDI file. I want the search engine to search for files with a .mid extension only, so it won't bring up pages or other documents. Now, thats pretty much all I can explain about my needs. I am a dummy when it comes to PHP and MySQL, so if someone knows of a way to use MySQL to make a database list of the MIDI files, please let me know how I can do that because I am a total dummy when it comes to MySQL like I've said. I've looked all over HotScripts.com for a script but I can't find one that will work for what I need it to do. Please help! Thanks!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 08-22-03, 08:29 AM
Squeezer's Avatar
Squeezer Squeezer is offline
Newbie Coder
 
Join Date: Jun 2003
Location: Luxembourg
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
hmm maybee a simple query like:

SELECT * FROM table WHERE filename LIKE ('%.mid'); will do the job??

(of course you'll need a php, perl or asp script to display the data in a userfriendly format)

Marc
__________________
Marc Giombetti - PHP Programmer
marc@giombetti.com
http://www.giombetti.com
Luxembourg - Europe
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #3 (permalink)  
Old 08-29-03, 06:38 PM
darkcarnival's Avatar
darkcarnival darkcarnival is offline
PHP/MySQL coder
 
Join Date: Jun 2003
Location: Michigan
Posts: 939
Thanks: 0
Thanked 0 Times in 0 Posts
well i made a program that searches and the program i made you add the files that you want to search. now its made to fit 3 different fields(or catagories) but im sure i could make it work for your use.but its not too hard
__________________
Elite Bulletin Board
http://elite-board.us
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Share database over the Internet nitinkedia The Lounge 2 11-20-03 03:07 PM
SQL database registration form help vinhkhuong PHP 3 10-10-03 04:49 AM
tracking down a database problem ... bjmcintosh ASP 1 08-29-03 08:52 AM
Share database over the internet nitinkedia PHP 0 07-11-03 01:22 AM
Share database over the Internet nitinkedia New Members & Introductions 1 07-10-03 03:50 PM


All times are GMT -5. The time now is 06:40 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.