$db = mysql_connect(localhost, ajic, bonifaci);
mysql_select_db(AJIC,$db);
$resultat = mysql_query("select * from contingut where tipus='agenda' order by data desc");
while ($row = mysql_fetch_array($resultat)) {
?>
$dataqf=$row["data"];
$anyqf=substr($dataqf,0,4);
$mesqf=substr($dataqf,5,2);
$diaqf=substr($dataqf,8,2);
echo $diaqf."-".$mesqf."-".$anyqf;
?>
|
}
mysql_free_result($resultat);
?>