Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End Band Website customization Re: Band Website customization

#63600
LonChaney
Member

Sorry, my bad… but this is still on my local box and I was trying to figure it out before I went live. I’m a newbie to php and mysql (but eager to learn) but I think I’ve narrowed it down a bit.

The Show Schedule seems to be built from this bit of code from build-table.php

/* build output */
$query = ‘SELECT show_id, date_starts, stime, venue, url, city, state,
DATE_FORMAT(date_starts,’%b %e’) as ds
FROM shows
WHERE date_starts >= NOW()
ORDER BY date_starts ASC’;
$result = mysql_query($query,$DATABASE_LINK) or die(mysql_error().’: ‘.$query);
if(mysql_num_rows($result))
{

I think the line: WHERE date_starts >= NOW() is what is preventing the past dates from showing but I’m not sure how to modify it.
I hope that is more helpful, thanks again, Lon