вот код краткой новости news.php
<?php
include"engine/db.php";
/*$dblocation = "localhost";
$dbuser = "root";
$dbpasswd = "";
$dbname = "newsloc";
$db_on = mysql_connect($dblocation,$dbuser,$dbpasswd)
or die ("Ошибка БД: ".mysql_error());
//Выбор БД
mysql_select_db($dbname, $db_on)
or die ("Ошибка БД: ".mysql_error());*/
//$res = mysql_query("SELECT * FROM news ORDER BY date");
$url=$_GET['url'];
$id_cat=$_GET['inc'];
$res=mysql_query("SELECT *
FROM `news` , `menu`
WHERE `news`.`id_cat` = `menu`.`id`
AND `menu`.`title_url` = '$url' ORDER BY date DESC");
while ($row = mysql_fetch_array($res) ){
echo
('
<table border="1" width="100%">
<tr>
<td rowspan="3" width="1px" heght="1px">');
/*echo
'
<img scr="news.loc/imghost/imgarticles/'.$row['uploadfile'].'">
';*/
if ($row['uploadfile']=="")
{}
else
{
echo '<img src="imghost/'.$row['uploadfile'].'">';
}
echo('</td>
<td>Дата добавления: '.$row['date'].'</td>
</tr>
<tr>
<td>
Автор статьи: '.$row['id_user'].'
</td>
</tr>
<tr><td valign="top" width="100%">
'.$row['cap'].'<br>
'.$row['ktext'].'<br>
<a href="?inc=fullnews">Подробнее</a>
</td></tr>
</table>
');
}
?>
Вот код полной новости fullnews.php
<?php
include "engine/db.php";
?>
<?php
mysql_connect('localhost','root','');
mysql_select_db('newsloc');
$res = mysql_query('SELECT * FROM `news` Where `alias`=' . (int) $_GET['alias']);
while($row = mysql_fetch_assoc($res)) {
echo ('
<table border="1" width="100%">
<tr>
<td rowspan="3" width="1px" heght="1px">');
if ($row['uploadfile']=="")
{}
else
{
echo '<img src="imghost/'.$row['uploadfile'].'">';
}
echo('</td>
<td>Дата добавления: '.$row['date'].'</td>
</tr>
<tr>
<td>
Автор статьи: '.$row['id_user'].'
</td>
</tr>
<tr><td valign="top" width="100%">
'.$row['cap'].'<br>
'.$row['ktext'].'<br>
</td></tr>
</table>
');
}
?>