|
|
|
|
if ($do != "archive")
{
$db = @mysql_connect($db_host,$db_user,$dbpass);
if ($id) $Query = " SELECT * from `article` WHERE ( `id` = '$id' ) ORDER BY id DESC LIMIT 1" ;
else $Query = " SELECT * from `article` ORDER BY id DESC LIMIT 1" ;
$Result = @mysql_db_query( $db_name , $Query );
$Row = @mysql_fetch_array( $Result );
@mysql_close($db);
?>
Articles and Reviews
Date:
if ($Row[source])
{
echo " | Source: ";
if ($Row[sourcelink]) echo "";
if ($Row[sourcelink]) echo "";
}
?>
echo $Row[summary]; ?>
if ($Row[photo] == "yes") {?>
}
echo $Row[text];
}
else
{?>
Archive
$db = @mysql_connect($db_host,$db_user,$dbpass);
$Query = " SELECT * from `article` ORDER BY date DESC, id DESC LIMIT $start, $limit" ;
$Result = @mysql_db_query( $db_name , $Query );
while ($Row = @mysql_fetch_array( $Result ))
{?>

Date:
}
@mysql_close($db);
echo " ";
if($lastpage > 1)
{
$pagination .= "\n";
echo $pagination;
}
}?> |
|
|
$db = @mysql_connect($db_host,$db_user,$dbpass);
$Query = " SELECT * from `article` ORDER BY date DESC, id DESC LIMIT 5" ;
$Result = @mysql_db_query( $db_name , $Query );
while ($Row = @mysql_fetch_array( $Result ))
{?>
echo $Row[title]; ?>
echo $Row[date]; ?>
}
@mysql_close($db);?>
|
|
|
|