* You are viewing the archive for the ‘Web Development’ Category

Get Your FREE Website Planning Guide

Jasdev Sondh December 24, 2009 Web Development No Comments

BigFanta Ltd has made available a newly compiled website planning guide, including sections on:

  1. Planning Your Website
  2. Building Your Website
  3. Marketing Your Website
  4. 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”…. Continue Reading

SQL query for WordPress Posts

Jasdev Sondh November 08, 2009 Web Development 1 Comment

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 … Continue Reading