I’ve added a guestbook! Click here to sign it! I’ve also updated my Movies, Soundtrack, Calendar, and Concerts pages (thanks to Erica’s brilliance and help with the php/mysql coding). I am still having trouble with the SELECT * call though, in regards to date. I’d love the date to show up like 4/10/2008 instead of 2008-04-10. Does anyone know how to do this?
$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";
is what I am currently using.
$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";
is what I used on my old site. It required a lot more code in the mysql call.
The difference is the SELECT DATE_FORMAT(date,\”%m/%d\”) section, but this doesn’t work with the current coding. Any suggestions?