|
|
 |
| Location : Home >> Events |
 |
$url = "";
$today = date("Y-m-d");
$db=mysql_connect("$dbhost","$dbserv","$dbpass") or die("Unable to connect to database");
mysql_select_db("$dbname",$db) or die("Unable to select database");
$result=mysql_query("select * from carclubs where start_date > '$today' order by start_date ASC",$db );
while($myrow=mysql_fetch_array($result))
{
$dvalue= $myrow[start_date];
$str = $dvalue;
$character1 = $str{0};
$character2 = $str{1};
$character3 = $str{2};
$character4 = $str{3};
$character6 = $str{5};
$character7 = $str{6};
$character9 = $str{8};
$character10 = $str{9};
$month = $character6.$character7;
$day = $character9.$character10;
$year = $character1.$character2.$character3.$character4;
if ($month=="01") { $month="January"; }
if ($month=="02") { $month="February"; }
if ($month=="03") { $month="March"; }
if ($month=="04") { $month="April"; }
if ($month=="05") { $month="May"; }
if ($month=="06") { $month="June"; }
if ($month=="07") { $month="July"; }
if ($month=="08") { $month="August"; }
if ($month=="09") { $month="September"; }
if ($month=="10") { $month="October"; }
if ($month=="11") { $month="November"; }
if ($month=="12") { $month="December"; }
$mydate = $month.' '.$day.' '.$year;
echo ("
| $myrow[cc_title] |
$mydate |
|
");
}
mysql_close($db);
?>
|
|
|
|
|
|
www.autopages.com.au
� Copyright 2001-2009 Australian Automotive Directory
All Rights Reserved
LINKS
|
|
|
|