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);
}
?>

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from Govtempdiary

Subscribe now to keep reading and get access to the full archive.

Continue reading