$selectgalls = "Select
articles.title,
articles.description,
artid,
article_cats.noticias
From
articles
Inner Join article_lookup ON articles.artid = article_lookup.JID
Inner Join article_cats ON article_lookup.CID = article_cats.id
where article_cats.name='SABIAS' and articles.caducidad >=CURDATE()
order by artid DESC";
$articles=&$db->EXECUTE($selectgalls);
if (!$articles) {
echo("
$selectgall = "Select
articles.title,
articles.description,
artid,
article_cats.noticias
From
articles
Inner Join article_lookup ON articles.artid = article_lookup.JID
Inner Join article_cats ON article_lookup.CID = article_cats.id
where article_cats.name='Columna' and articles.caducidad >=CURDATE()
order by artid DESC";
$article=&$db->EXECUTE($selectgall);
if (!$article) {
echo("
=CURDATE() and articles.artid = JID AND CID = '5' AND (idorden<=6)";
$order1 = " ORDER BY articles.idorden ASC ";
$article=&$db->EXECUTE($query1 . $wherel .$order1);
if (!$article) {
echo("
=CURDATE() and articles.artid = JID AND CID = '$dator' AND (idorden>6)";
$order1 = " ORDER BY articles.idorden ASC ";
$article=&$db->EXECUTE($query1 . $wherel .$order1);
if (!$article) {
echo("
Error al mostrar categorias! ".
"Error: ");
exit();
}
$i=1;
while (!$article->EOF) {
if($i%1<>0)
echo"
=CURDATE()";
$contarmas=&$db->EXECUTE($consultan);
$totamas=$contarmas->RecordCount();
$_SESSION['totacmas'] = $totamas;
$_SESSION['iniciallmas'] = 0;
}
$consultan="Select distinct
articles.artid AS artid,articles.title,articles.balazo AS balazo,
articles.relacion AS relacion,article_lookup.CID,article_lookup.JID,
articles.description AS descr,articles.img AS img,
articles.notadepie AS notadepie,article_cats.idmenu
From
articles
Inner Join article_lookup ON articles.artid = article_lookup.JID
Inner Join article_cats ON article_lookup.CID = article_cats.id
WHERE articles.caducidad>=CURDATE()
limit ".$_SESSION['iniciallmas'].",2";
$article=&$db->EXECUTE($consultan);
if (!$article) {
echo("
Error al mostrar categorias! ".
"Error: ");
exit();
}
$i=1;
while (!$article->EOF) {
if($i%1<>0)
echo"