Новините да се гледат индивидуално

[sianbg2]

http://web-tourist.net/login/login/view.php?st=2277 как да направя така ,че да може новините да се гледат 1 по една.

 

[nom3r1]

view.php

<?php
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

function secure($var) { 
return addslashes(htmlspecialchars($var)); 
} 
$id = secure(@$_GET['id']);
$query = mysql_query("SELECT * FROM news WHERE id = '$id'")or die(mysql_error()); 
$nums = mysql_num_rows($query); 
if(($nums > 0) && ($id != NULL)) { 
$row = mysql_fetch_object($query);
$name = $row -> name;
$news = $row -> news;
$id = $row -> id;

echo "<b>$name</b><br />";
$echo = wordwrap($news, 40, "<br>", true); 
echo $echo;
} 
else if(!$_GET['id']) { 
echo "Грешка!"; 
} 
elseif ($nums == 0) { 
echo "Грешка!"; 
} 
?>

index.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>
<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name");
$news = mysql_result($select, $i, "news");
echo '
'.$news.' -> преразгледай новината <a href="view.php?id='.$id.'">ВИЖ</a>';
}

mysql_close();
?>

 

[sianbg2]

<a href="view.php?id='.$id.'">ВИЖ</a>';

Не трябва ли да е

<a href="view.php?id='.$i.'">ВИЖ</a>';

По 1 начин нестава.
По 2 начин става обаче не започва от id 1 а от id 0 Тоест когато дам да преглеждам 2 новина ми изкарва 1 а когато дам 1 ми изкарва,че няма така новина.

 

[proba]

<table width="300" height="10" border="1"> 
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table> 
<?php 
//настройки за база данни 
$dbhost = "db host"; 
$dbuser = "db user"; 
$dbpass = "db pass"; 
$dbname = "db name"; 
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error()); 
mysql_select_db($dbname, $conn)or die(mysql_error()); 

$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error()); 
$num = mysql_num_rows($select); 
for ($i=0;$i<$num;$i++) { 
$name = mysql_result($select, $i, "name"); 
$news = mysql_result($select, $i, "news"); 
$id = mysql_result($select, $i, "id"); 
echo ' 
'.$news.' -> преразгледай новината <a href="view.php?id='.$id.'">ВИЖ</a>'; 
} 

mysql_close(); 
?>

Запвоядай :lol: 8) :?:

 

[nom3r1]

index.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>
<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

$our = mysql_query("SELECT * FROM news ORDER BY id DESC"); 
while(@$r=mysql_fetch_array($our)){
echo "
<a href='view.php?id=".$r['id']."'><b>".$r['name']."</b></a>

";
} 
?>

:roll:

 

[nom3r1]

Стана ли :roll: