September 21st, 2005, 05:01 PM
|
|
Contributing User
|
|
Join Date: Mar 2003
Posts: 189
Time spent in forums: 1 Day 23 h 24 m 11 sec
Reputation Power: 6
|
|
|
Wanted : Custom Mysql search class .. $10-$15
Price: $10-$15
Payment: Via PayPal
Explaination
I have 3 tables...
`words` [id, Title] [MyISAM]
`song_index` [wordid, songid] [heap]
`index_data` [songid ... other info] [innodb]
What I need to be done shouldn't be much sql work. I need to search `words` for say "Cool song" where it matches Cool & Song , and arrays the matching ID's [just NOT cool or song], and loops through song_index and grabs the songid's and then prints the data from index_Data [i can do the prinintg of index_data, you just have to connect it]
On `index_data` their is a column "playtime" [index_data.playtime] which if is supplied, only songs with a playtime of X should be displayed. [ex: WHERE playtime > 60]
Please then incoprerate a simple paging class (prev , 1 ,2 ,3 ,next)
I would like this to be in an clean script, preferably a class with an example.
I wan't to see it working before payment is sent.
Edit: Attachment of SQL Dump for table structure, and 10 examples is below.
Last edited by Filenetwork : September 21st, 2005 at 06:07 PM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
