$sql_mtr = "SELECT a.*, date_format(dt_inicio,'%d/%m/%Y') AS data, date_format(dt_termino,'%d/%m/%Y') AS data2 FROM asp_evento a WHERE a.publica='1' AND a.id_idioma='2' ORDER BY dt_inicio DESC limit 3";
$sql = mysql_query($sql_mtr) or die("Erro no sql: $sql_mtr " . mysql_error());
?>
 |
| |
|
| |
|
 |
 |
| |
//Select do comunicado
$sql_str = "SELECT *,date_format(dt_registro, '%d/%m/%Y')as data FROM asp_comunicado WHERE publica='1' AND id_idioma='2' ORDER BY dt_registro desc limit 4";
$sql = mysql_query($sql_str) or die("Erro no sql: $sql_str " . mysql_error());
while($array = mysql_fetch_array($sql)){
?>
 |
echo $array[titulo] ?> |
 |
} ?>
|
| |
|