global $wpdb;
$categoriesData = $wpdb->get_results("SELECT c.*,ct.* FROM {$wpdb->prefix}terms
as c JOIN {$wpdb->prefix}term_taxonomy as ct ON c.term_id=ct.term_id
WHERE ct.taxonomy='category' ");
foreach($categoriesData as $key=>$category) {
echo $category->name;
}
<?php
global $wpdb;
$cat="2"//Parent category id
$categoriesData = $wpdb->get_results("SELECT c.*,ct.* FROM
{$wpdb->prefix}terms as c JOIN {$wpdb->prefix}term_taxonomy as ct
ON c.term_id=ct.term_id WHERE ct.taxonomy='category'
AND ct.parent ='$cat' ");
?>
<?php
global $wpdb;
$querystr = " SELECT distinct(post_title) ,ID,post_title FROM $wpdb->posts
WHERE post_type='page' AND post_status='publish' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
?>
<?php
global $wpdb;
$querystr = " SELECT distinct(post_title) ,ID,post_title FROM $wpdb->posts
WHERE post_type='post' AND post_status='publish' ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
?>
<?php
global $wpdb;
$const="4,8,7"; //category Ids
$querystr = "SELECT distinct(wposts.post_title),wposts.ID FROM $wpdb->posts
wposts LEFT JOIN $wpdb->term_relationships ON (wposts.ID =
$wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id =
$wpdb->term_taxonomy.term_taxonomy_id) WHERE $wpdb->term_taxonomy.taxonomy
= 'category' AND $wpdb->term_taxonomy.term_id IN($const) ORDER BY rand() ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
?>
<?php
echo $_SERVER['REMOTE_ADDR']
?>
<?php
echo $_SERVER['HTTP_REFERER']
//will return the previous page
?>
<?php
$startDate=explode("-", "02-08-2010");
$endDate=explode("-", "26-04-2007");
echo gregoriantojd($startDate[1], $startDate[0], $startDate[2])
- gregoriantojd($endDate[1], $endDate[0], $endDate[2]);
//1194
?>
Zend | Magento Certified PHP | eCommerce Architect
Pramod T P 