Important Orders For the Month of March 2018

$server = “server.govtempdiary.com”;
$user = “govtempd_adminx”;
$pwd = “Fsi;eB_]fJ4u”;
$db_name = “govtempd_govtempdiarydb”;

$connection = mysql_connect($server, $user, $pwd);
mysql_select_db($db_name);

if(!$connection){
die(“Connection failed: “. mysql_error());
}
else{

$sql = ‘select DATE_FORMAT(STR_TO_DATE(meta_date.meta_value, \’%d %M,%Y\’), \’%d-%m-%Y\’) as \’Date\’, meta_number.meta_value as \’Number\’, ‘
. ‘post.post_title as \’Name\’,post.guid as \’Url\’ from `wp_posts` post ‘
. ‘join `wp_postmeta` meta_date on meta_date.post_id = post.id and meta_date.meta_key = \’ref_date\’ ‘
. ‘join `wp_postmeta` meta_number on meta_number.post_id = post.id and meta_number.meta_key = \’ref_number\’ ‘
. ‘join `wp_postmeta` page on page.post_id = post.id and page.meta_key = \’page_id\’ ‘
. ‘where post.post_type=\’post\’ and post.post_status=\’publish\’ and page.meta_value like \’%35641%\’ ‘
. ‘order by STR_TO_DATE(meta_date.meta_value, \’%d %M,%Y\’) desc’;

$result = mysql_query($sql);

if(!$result){
die(‘Query failed’);
mysql_close($connection);
}

echo ‘

‘;while($row = mysql_fetch_assoc($result)){
echo ”;echo ”;
echo ”;
echo ”;
}echo ‘

DATE	OM No. & ORDER LINK
‘. $row[‘Date’] . ‘	‘ . $row[‘Number’] . ” . ‘‘ . $row[‘Name’] . ‘‘ . ‘

‘;

mysql_free_result($result);

mysql_close($connection);
}
?>