{"id":99,"date":"2008-04-11T07:06:39","date_gmt":"2008-04-11T07:06:39","guid":{"rendered":"http:\/\/www.ariellehaze.com\/?p=99"},"modified":"2009-03-23T17:46:54","modified_gmt":"2009-03-24T01:46:54","slug":"site-updated","status":"publish","type":"post","link":"https:\/\/www.mirdonamy.com\/?p=99","title":{"rendered":"Site Updated!"},"content":{"rendered":"<p>I&#8217;ve added a guestbook!  <a href=\"http:\/\/www.mirdonamy.com\/?page_id=92\">Click here<\/a> to sign it!  I&#8217;ve also updated my Movies, Soundtrack, Calendar, and Concerts pages (thanks to Erica&#8217;s brilliance and help with the php\/mysql coding).  I am still having trouble with the SELECT * call though, in regards to date.  I&#8217;d love the date to show up like 4\/10\/2008 instead of 2008-04-10.  Does anyone know how to do this?  <\/p>\n<p><em><code>$sql = \"SELECT * FROM calendar WHERE toggle = 1 && DATE_FORMAT(date,\\\"%m\\,\\%d\\\") >= DATE_FORMAT(curdate(),\\\"%m\\,\\%d\\\") ORDER by DATE_FORMAT(date,\\\"%m\\,\\%d\\\") LIMIT 0,45\";<\/code><\/em><br \/>\nis what I am currently using.<\/p>\n<p><em><code>$calenQuery = \"SELECT DATE_FORMAT(date,\\\"%m\/%d\\\"),title,content,link FROM calendar WHERE toggle = 1 && DATE_FORMAT(date,\\\"%m\\,\\%d\\\") >= DATE_FORMAT(curdate(),\\\"%m\\,\\%d\\\") ORDER by DATE_FORMAT(date,\\\"%m\\,\\%d\\\") LIMIT 0,25\";<\/code><\/em><br \/>\nis what I used on my old site.  It required a lot more code in the mysql call.  <\/p>\n<p>The difference is the SELECT DATE_FORMAT(date,\\&#8221;%m\/%d\\&#8221;) section, but this doesn&#8217;t work with the current coding.  Any suggestions?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve added a guestbook! Click here to sign it! I&#8217;ve also updated my Movies, Soundtrack, Calendar, and Concerts pages (thanks to Erica&#8217;s brilliance and help with the php\/mysql coding). I am still having trouble with the SELECT * call though, in regards to date. I&#8217;d love the date to show up like 4\/10\/2008 instead of &hellip; <\/p>\n<p><a class=\"more-link block-button\" href=\"https:\/\/www.mirdonamy.com\/?p=99\">Continue reading &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-blogging"],"_links":{"self":[{"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":1,"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":472,"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions\/472"}],"wp:attachment":[{"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mirdonamy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}