|
| quote: | Originally posted by Jocker
checking for stock in different shops if practicaly inviable. you see, different sites have different search engines, and you have to know the details of each engine's framework to be able to construct a thing to retrieve the results. for example, juno got the weirdest engine i've seen. if you search for "envio", you'll get some results, among which is the one i want ("envio - touched by the sun"). but if you search for "envio touched", it will give you 0 results. i can provide the links to the search engines or the forms on my page (you'll have to input the data only once, and it will open the search results on all the sites). but in order to say "in stock" - the only way to check this is when the shops themselves would send me a list of what's new in stock (which i doubt they'll do).
including the "genre" field is the good idea - i didn't do it in the first place. highlighting the new additions is easy - i can simply mark the last 5 releases added as new ones.
right now i have an index file, which displays all the results (i have already implemented sorting - you can sort by the release date, artist name, label or title of the release), a page to add the releases and a page to search at juno. still to be done: the genre field, categories (to distinguish between singles and albums), search engine within the site (to search for strings in any field - artist, title, label or date), login and editing system, and the unified search engine for other stores. |
Sorry didn't explain what I meant properly.
What I meant was a filter on your site, filtering your content.
So let's say your DB contains Holden - Nothing (93 returning mix) @ Juno and Chem
It also contains Nathan Fake - Outhouse @ Chem.
Running the filter on your site over prog will return both records, but having the option of selecting prog @ Juno will only return Holden - Nothing.
If people(read admins) update it enough, it WILL only have instock items there due to people fixing up stock levels after they've checked the site.
SQL wise (incase I still don't make sense).
SELECT * FROM tracks_db WHERE genre='Prog' & shop='Juno' & stock='1'
[that's a really bad statement and also the way that all teh data is in one table, but this is not RDMS course/lecture, and I'm sure you'll have it broken down into mulitple DB's and use inner-joins for the queries]
Looking @ what's done and what's to do, other then my little thing above, I can't think of anything else, other then something visually pleasing  
Once again, thanks for your time and efforts, I'm sure it will not be forgotten.
--djway
___________________
|
