listen to music

http://listen.grooveshark.com/

creating custom fields in simple machines forum

http://custom.simplemachines.org/mods/index.php?action=parse
http://www.simplemachines.org/community/index.php?topic=294269.0

lease of contract

http://legal-forms.philsite.net/lease-contract.htm

how to remove duplicate rows in mysql db

Step 1: Move the non duplicates (unique tuples) into a temporary table

CREATE TABLE new_table as
SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];

Step 2: delete delete the old table
We no longer need the table with all the duplicate entries, so drop it!

DROP TABLE old_table;

Step 3: rename the new_table to the name of the old_table

RENAME TABLE new_table TO old_table;

And of course, don't forget to fix your buggy code to stop inserting duplicates!

upload multiple files to specific Magento products

- This is possible by creating a custom textarea attribute. Then, create a folder where you will save the files to be linked in the textarea attribute.

Magento: Display category list on the left column

http://www.magentocommerce.com/boards/viewthread/4722/#t17585

Elastix

http://www.elastix.org/index.php?option=com_openwiki&Itemid=27&id=installation

installing AsteriskNOW

1. http://www.youtube.com/watch?v=tn9TzJ6eZW0&feature=related   - linux text installation
2. http://www.youtube.com/watch?v=ONOxNJquatk
3. http://www.elastix.org/index.php?option=com_openwiki&Itemid=27&id=installation    -    elastix