$sql="SELECT * FROM ARTICULOS_T WHERE CATEGORIA='1' ORDER BY ID DESC LIMIT 12";
$result=mysql_query($sql);
while ($myrow=mysql_fetch_array($result)){
$idmapeo=$myrow["ID"];
$titulotab=$myrow["TITULO"];
$titulo = str_replace(""", "\"", $titulo);
$imagen=$myrow["IMAGEN"];
if ($imagen){
$sql5="SELECT * FROM IMAGENES_T WHERE ID='$imagen'";
$sql6=mysql_query($sql5);
$sitio6=mysql_fetch_array($sql6);
$url=$sitio6["URL"];
$grafico="";
}
else {
$grafico=" ";
}
$dc2=$myrow["DC"];
$dc2=str_replace(""", "\"", $dc2);
$dc2=str_replace("\n",' ',$dc2);
echo "\n";
}
?>
$sql="SELECT * FROM ARTICULOS_T WHERE CATEGORIA='3' ORDER BY ID DESC LIMIT 12";
$result=mysql_query($sql);
while ($myrow=mysql_fetch_array($result)){
$idmapeo=$myrow["ID"];
$titulotab=$myrow["TITULO"];
$titulo = str_replace(""", "\"", $titulo);
$imagen=$myrow["IMAGEN"];
if ($imagen){
$sql5="SELECT * FROM IMAGENES_T WHERE ID='$imagen'";
$sql6=mysql_query($sql5);
$sitio6=mysql_fetch_array($sql6);
$url=$sitio6["URL"];
$grafico="";
}
else {
$grafico=" ";
}
$dc2=$myrow["DC"];
$dc2=str_replace(""", "\"", $dc2);
$dc2=str_replace("\n",' ',$dc2);
echo "\n";
}
?>
|
|
|