Unnamed
public php v1 · immutable<?php require("cal-config.php"); $conn = mysql_connect($hostname,$username,$password); mysql_select_db($database); $query = "select distinct(concat(month(post_date),'', day(post_date),'',year(post_date))) as date from ".$table_prefix."posts where post_type='post'"; $result = mysql_query($query); $r = "[{post_dates:["; while ( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) { $r .= "'".$row['date']."'"; } $r .= "]}"; echo $r;?>