Jeffrey Flowers wrote:
>What I would like to hear is how other people are putting MySQL to work in
>their home environment.
Like you said yourself the most obvious application is cataloging music
CD's.
What I'm doing is using it to keep a track of magazine cover disks. I got
really
annoyed with knowing that I have a particular program, but not being sure
where
on the collection of cover CD/DVD's the darned thing is. Just got a simple
script
that traverses the tree of a CD and inserts the filename, disk id, etc into
a suitable
MySQL database.
Someone I was speaking to had a darned good idea. Now we've got 100+GB
disks why not use the binary column type to build a library of MP3 files
for use
with these 'MP3man' type devices, (SonicBlue Rio, Samsung Yepp, etc).
Then he could use a nice PHP/HTML front end to select what type of music
he fancied, then add further preferences, before being given a final list
that
could then be automatically uploaded to his player.
bob cross
disclaimer: writing for myself.
(filter: sql query on mysql database table).
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php