Въпрос относно ваденето на резултати от MySQL

P

Pupe64etoo_92

Registered
Правя например една колона views във таблица news и вкарвам да речем във fullnews.php този код
Код: 
$id_news = $_GET['news_view'];
$nums = mysql_query("SELECT * FROM `news` WHERE `id_news`='$id_news'"); 
while ($row = mysql_fetch_array($nums)) { 
$view = $row[view];
$views = $row[views]; 
$views++; 
$sql = "UPDATE `news` SET views='$views' WHERE `id_news`='$id_news'"; 
mysql_query($sql);

Забележете има ограничение WHERE `id_news`='$id_news
искам да изкарам колко пъти е видяна за дадена новина във страница news.php
така както е кода си избира дадена новина и ми изкарва на всички новини които са в news.php там няяма ограничение за да ми вади ресулта.
Код: 
$idview = $_GET['news_view'];
$nums = mysql_query("SELECT id_news, views FROM `news` "); 
$row = mysql_fetch_array($nums); 
$views = $row[views];

ако го направя така не ми вади нищо, тоест задавам Where id_news='$idview'
Код: 
$idview = $_GET['news_view'];
$nums = mysql_query("SELECT id_news, views FROM `news` WHERE id_news=$idview "); 
$row = mysql_fetch_array($nums); 
$views = $row[views];
 
във fullnews.php ги изкарвам ама във news.php неставaва . Пропчети какво точно искам да направя. икам да изкарам във news.php и виж във news.php е друга променливата ми за GET[news_view];
както мисля трябва да стане
Код: 
$idview = $_GET['news_view'];
$nums = mysql_query("SELECT id_news, views FROM `news` WHERE id_news='$idview' ");
$row = mysql_fetch_array($nums);
$views = $row[views];
echo "$views"
но не ми ги вади така без WHERE id_news=$idview ми ги вади но си избира новина с произволно id и на всяка новина в news ми вади колко пъти е видяна новината със произволното id.
 
пак не ги вади ето ти кода
fullnews.php
Код: 
<?php include ("config.php"); ?>
<?php 
 
$id_news = $_GET['news_view'];
$nums = mysql_query("SELECT * FROM `news` WHERE `id_news`='$id_news'"); 
while ($row = mysql_fetch_array($nums)) { 
$view = $row[view];
$views = $row[views]; 
$views++; 
$sql = "UPDATE `news` SET views='$views' WHERE `id_news`='$id_news'"; 
mysql_query($sql); 
} 
$dog = mysql_query("SELECT count(id_com) as comments_total FROM comments WHERE id_news = '$id_news'");
$rowas=mysql_fetch_array($dog);{
$broicom = $rowas[comments_total];
}
$archive="SELECT * FROM news WHERE id_news = '$id_news'"; 
$sqla=mysql_query($archive);
$rowa = mysql_fetch_array($sqla);{
$title = $rowa[title];
$potrebitel = $rowa[potrebitel];
$chas = $rowa[chas];
$minuti = $rowa[minuti];
$den = $rowa[den];
$mesec = $rowa[mesec];
$godina = $rowa[godina];  
$newstext = $rowa[newstext];
$url = $rowa[url];
}
echo "
<title>CS-XIPNOZA.INFO - $title</title>
<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr> 
<td width=552 height=auto background=/images/newscomment/newszaglavie.gif><b><div align='left' class=ws11> $title </div></b>
</td> 
</tr> 
<tr> 
<td> 
<table width=552 height=auto cellpadding=0 cellspacing=0> 
<tr>
<td width=552 height=auto background=/images/newscomment/textnews.jpg><font class='ws10' color='#FFFFFF' style='width:550; height:auto;'><div style='padding:3px; text-align:justify;'><img style=padding:2px; align=right src=$url>$newstext<br /><br /></div></font>
</td>
</tr>
</table>
<tr>
<td background=/images/newscomment/infocomment.gif>
<font color=#FFFFFF class=ws9> Публикувана на 
<font size=2pt color=#00FF00><strong>$den/$mesec/$godina</strong></font>
<font color=#FFFFFF class=ws9> от</font><font size=2pt color=#00FF00> $potrebitel</font><font color=#FFFFFF class=ws9>  <img src='images/newscomment/coment.png' /> Коментари - <b><font size=2pt color=#00FF00>$broicom</font></b><font color='#fff' class='ws9'> Прегледана - <b><font size=2pt color=#00FF00>$views</font></b></td></tr></table>"; 

?>
<br />
<table align="center" width="551" height="auto">
<tr>
<td width="551" height="27" style="border:#969696 1px solid"><div style="background-image:url(/images/newscomment/newszaglavie.gif)" align="center" class="ws11"><b>Коментари</b></div>
<?php
include ("config.php");
$id = $_GET['news_view'];

$pp = "10";
$page=$_GET['page']; 

if(!$_GET['page']) 
{
$page="1";
}
$limit = ($pp*$page)-$pp;
$redove=mysql_query("SELECT * FROM comments WHERE id_news = '$id' ORDER BY id_com DESC");
$max=mysql_numrows($redove); 
$total=ceil($max/$pp);
$query="SELECT * FROM comments WHERE id_news = '$id' ORDER BY id_com DESC LIMIT $limit,$pp"; 
$result=mysql_query($query);
$alternate = "2"; 
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {

$username=mysql_result($result,$i,"username");
$minuti=mysql_result($result,$i,"minuti");
$chas=mysql_result($result,$i,"chas");
$den=mysql_result($result,$i,"den");
$mesec=mysql_result($result,$i,"mesec");
$godina=mysql_result($result,$i,"godina");
$comment=mysql_result($result,$i,"comment");

if ($alternate == "1") {
$color = "#6F6F6F"; 
$alternate = "2";
}
else {
$color = "#5A595A";
$alternate = "1";
} 
echo "
<table bgcolor=$color align=center width=552px height=auto cellpadding=0 cellspacing=0>
<tr><td style='padding:2px' align=center><br />
<table align=center border=1px solid bordercolor=#000000 width=550 height=19 cellpadding=0 cellspacing=0> 
<tr>
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>$comment</div></font>
</td>
</tr>
<tr>
<td>
<table width=550 height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил: </font><font size=2pt color=#00FF00><strong>$username</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>$den/$mesec/$godina - $chas:$minuti</strong></font>
</td></tr></table></td></tr></table><br /></td></tr></table>";
$i++;
}

news.php
Код: 
<?php
include ("config.php");
$idview = $_GET['news_view'];
$nums = mysql_query("SELECT id_news, views FROM `news` WHERE `id_news`='{$idview}'"); 
$row = mysql_fetch_array($nums); 
$views = $row[views];
$pp = "6";
$page=$_GET['page'];

if(!$_GET['page']) 
{
$page="1";
}
$limit = ($pp*$page)-$pp; 
$redove=mysql_query("SELECT * FROM news");
$max=mysql_numrows($redove); 
$total=ceil($max/$pp); 
$query="SELECT * FROM news ORDER BY `id_news` DESC LIMIT $limit,$pp";
$result=mysql_query($query);
$alternate = "2"; 
$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {
$id_news=mysql_result($result,$i,"id_news");
$title=mysql_result($result,$i,"title");
$newstext=mysql_result($result,$i,"newstext");
$minuti=mysql_result($result,$i,"minuti");
$chas=mysql_result($result,$i,"chas");
$den=mysql_result($result,$i,"den");
$mesec=mysql_result($result,$i,"mesec");
$godina=mysql_result($result,$i,"godina");
$potrebitel=mysql_result($result,$i,"potrebitel");
$url=mysql_result($result,$i,"url");

if ($alternate == "1") {
$color = "#5A595A"; 
$alternate = "2";
}
else {
$color = "#6F6F6F";
$alternate = "1";
} 

echo "
<table bgcolor=$color align=center width=593px height=auto cellpadding=0 cellspacing=0>
<tr><td align=center><br />
<table align=center border=1px solid bordercolor=#000000 width=552 cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/newszaglavie.gif><strong><a href=fullnews.php?news_view=$id_news><div align='left' class=ws11> $title </div></a>
</td>
</tr>
<tr>
<td>
<table width=552 class=news height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/textnews.jpg><font class='ws10' color='#FFFFFF' style='width:550; height:auto;'><div style='padding:3px; text-align:justify;'><img style=padding:2px; align=right src=$url>$newstext<br /></div></font>
<a href=fullnews.php?news_view=$id_news><p align=right><font size=2pt style='width:552; height:auto'><strong>Прочети цялата новина >> </strong></p></a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td background=/images/newscomment/infocomment.gif><div id='userpanel' align='left'>
<font color=#FFFFFF class=ws9> Публикувана на 
<font size=2pt color=#00FF00><strong>$den/$mesec/$godina</strong></font>
<font color=#FFFFFF class=ws9> от</font><font size=2pt color=#00FF00> <a href=profile.php>$potrebitel</a></font><font color=#FFFFFF class=ws9>  <img src='images/newscomment/coment.png' /> Коментари - <b><font size=2pt color=#00FF00>$broicom</font></b><font color='#fff' class='ws9'> Прегледана - <b><font size=2pt color=#00FF00>$views</font></b></td></tr></table><br /></td></tr></table><center>";
$i++;
}
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе