How to view ZIP file contents on Mac without extracting files
Viewing the contents of a ZIP file on a Mac without extracting the ZIP content has been missing from the basic functionality available on a standard OS X installation. Now you can download a small freeware plug-in for 'QuickLook' which fixes this issue. Allowing you to view the contents before extracting the complete ZIP file.
View the developer's website for the download and installation instruction. Tested on Mac OS X Snow Leopard.
Get Your FREE Website Planning Guide
BigFanta Ltd has made available a newly compiled website planning guide, including sections on:
- Planning Your Website
- Building Your Website
- Marketing Your Website
- Improving Your Website
This provide usefully information on your to structure, built and most importantly marketing your website. Having a feature/media rich website is unless you have traffic to generate revenue. This may be through sales, memberships, advertisements, etc. Traffic generation in itself is a huge field of possible solutions, from SEO, Internet Marketing, Offline and Online Advertisements. Therefore along with BigFanta Website Planning Guide, you also get an additional eBook "Online Traffic Generation Methods".
SQL query for WordPress Posts
I have been trying to write a SQL select query for getting the all the posts made in wordpress blog (to create a latest news banner). This seem easy enough, doesn't it. The problems arose due to the post revising done by the wordpress blog application, this was just added a layer of confusion. The wordpress blog database stores multiple records for a single post, one record each saved version of the post. However removing this layer, I found that a simple select query will do the job nicely, and here it is:
SELECT * FROM 'wp_posts' WHERE post_status='publish' order by post_date DESC
Nice and Simple 