The Hype Machine is a huge aggregation of music blogs. sooooooooooo much music. it's like radio, with the option for download, featuring more pre-release/rare goodness than you will ever manage to listen to.
b05q's blog
drupal tip: save time with a js/css dropdown menu
by b05qi strongly recommend using a javascript/css drop-down menu to replace the standard issue naviagtion module. it's a compelte waste of time to sit there wait/click through 3 pages (e.g. 'Administer', 'Logs', 'Status Report'), when you know exactly where you want to go. With a drop-down menu, you just click 'Status Report'.
drupal how to: make a custom block that processes url arguments
by b05quseful db functions for drupal
by b05qAnytime you pass variables to your database, you need to escape them (tell the db that 'this is data and not code'). This protects you from cross-site scripting. Drupal is no different. but fortunately it's easy. check it out.
for example, instead of this:
db_query("SELECT COUNT(*) FROM {node} WHERE type = ".$type." AND status = 1")
you would want to use something like this:
db_query('SELECT COUNT(*) FROM {node} WHERE type = %s AND status = 1', $type)