Изкарване на новина

H

haus

Registered
Здравеите имам игра и във тази игра има вестник и искам да попитам как да извеждам различна новина от този вестник при всеки рефреш ?
 
а ще може ли да ми кажеш как точно до го направя защото това

mysql_query("SELECT * FROM tablicata ORDER by id RAND LIMIT 1");

нищо не ми говори може ли малко по конкретно
 
Код: 
$query = mysql_query("SELECT * FROM tablicata ORDER by id RAND LIMIT 1");
while($row = mysql_fetch_array($query)){
$ime = $row['reda s imeto'];
$text = $row['reda s texta'];
echo"$ime<br>$text";
}
 
виш кода на весника и може ли да ми го направиш по него плс


Код: 
<?php
if(!isset($_SESSION['name'])) {
echo ' Не си логнат.';
 } else
{
?>

<a href="home.php?a=vestnik" class="showvesnika"><img src="images/stats/vest.gif" border="0" > Весник</a>
 <a href="home.php?a=addvestnik" class="addvesnika"><img src="images/menu/edit.gif" border="0" > Добави Новина</a>
 <h3 class='stranicamenu'><center>Вестник</center></h2>
 
 
 
<?php
$profile = "home.php?a=profile&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
?> 
<?php
$sql = mysql_query("SELECT * FROM `vesnik` order by `id` DESC limit 14") or die(mysql_error());
$i = 0;
echo "<table><tr><td>";

while($raw = mysql_fetch_array($sql)) {
$i += 1;
$zaglavie = ($raw['zaglavie']);
$content = nl2br($raw['content']);
$avtor = ($raw['avtor']);
$id = ($raw['idd']);
$go1=(mysql_query("SELECT avatar FROM users WHERE name='$avtor'"));
$avatar=$go1['avatar'];
echo "<div id='header5'>
<div><a href=\"$profile=$id\" class='nad'><img src='images/avatar/0.gif' style='width:50px; height:50px;'><br /><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
}
echo "</td></tr></table>";
}
?>
 
Така, ще ти ги вади по 14 различни новини при презареждане.

Код: 
<?php
if(!isset($_SESSION['name'])) {
echo ' Не си логнат.';
} else
{
?>

<a href="home.php?a=vestnik" class="showvesnika"><img src="images/stats/vest.gif" border="0" > Весник</a>
<a href="home.php?a=addvestnik" class="addvesnika"><img src="images/menu/edit.gif" border="0" > Добави Новина</a>
<h3 class='stranicamenu'><center>Вестник</center></h2>



<?php
$profile = "home.php?a=profile&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
?>
<?php
$sql = mysql_query("SELECT * FROM `vesnik` [color=red]ORDER BY RAND() LIMIT 1[/color]") or die(mysql_error());
$i = 0;
echo "<table><tr><td>";

while($raw = mysql_fetch_array($sql)) {
$i += 1;
$zaglavie = ($raw['zaglavie']);
$content = nl2br($raw['content']);
$avtor = ($raw['avtor']);
$id = ($raw['idd']);
$go1=(mysql_query("SELECT avatar FROM users WHERE name='$avtor'"));
$avatar=$go1['avatar'];
echo "<div id='header5'>
<div><a href=\"$profile=$id\" class='nad'><img src='images/avatar/0.gif' style='width:50px; height:50px;'><br /><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
}
echo "</td></tr></table>";
}
?>
Увеличете...
 
да но ми дава някаква грешка

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RAND limit 14' at line 1
 
<?php
if(!isset($_SESSION['name'])) {
echo ' Не си логнат.';
} else
{
?>

<a href="home.php?a=vestnik" class="showvesnika"><img src="images/stats/vest.gif" border="0" > Весник</a>
<a href="home.php?a=addvestnik" class="addvesnika"><img src="images/menu/edit.gif" border="0" > Добави Новина</a>
<h3 class='stranicamenu'><center>Вестник</center></h2>



<?php
$profile = "home.php?a=profile&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
?>
<?php
$sql = mysql_query("SELECT * FROM `vesnik` ORDER BY `id` RAND() DESK LIMIT 1") or die(mysql_error());
$i = 0;
echo "<table><tr><td>";
$raw = mysql_fetch_array($sql);
$i += 1;
$zaglavie = ($raw['zaglavie']);
$content = nl2br($raw['content']);
$avtor = ($raw['avtor']);
$id = ($raw['idd']);
$go1=(mysql_query("SELECT avatar FROM users WHERE name='$avtor'"));
$avatar=$go1['avatar'];
echo "<div id='header5'>
<div><a href=\"$profile=$id\" class='nad'><img src='images/avatar/0.gif' style='width:50px; height:50px;'><br /><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
echo "</td></tr></table>";
}
?>
Увеличете...
 
Код: 
<?php
if(!isset($_SESSION['name'])) {
echo ' Не си логнат.';
} else
{
?>

<a href="home.php?a=vestnik" class="showvesnika"><img src="images/stats/vest.gif" border="0" > Весник</a>
<a href="home.php?a=addvestnik" class="addvesnika"><img src="images/menu/edit.gif" border="0" > Добави Новина</a>
<h3 class='stranicamenu'><center>Вестник</center></h2>



<?php
$profile = "home.php?a=profile&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
?>
<?php
$sql = mysql_query("SELECT * FROM `vesnik` ORDER BY `id` RAND() DESC LIMIT 1") or die(mysql_error());
$i = 0;
echo "<table><tr><td>";
$raw = mysql_fetch_array($sql);
$i += 1;
$zaglavie = ($raw['zaglavie']);
$content = nl2br($raw['content']);
$avtor = ($raw['avtor']);
$id = ($raw['idd']);
$go1=(mysql_query("SELECT avatar FROM users WHERE name='$avtor'"));
$avatar=$go1['avatar'];
echo "<div id='header5'>
<div><a href=\"$profile=$id\" class='nad'><img src='images/avatar/0.gif' style='width:50px; height:50px;'><br /><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
echo "</td></tr></table>";
}
?>

Така ще стане :?:
 
Код: 
<?php 
if(!isset($_SESSION['name'])) { 
echo ' Не си логнат.'; 
 } else 
{ 
?> 

<a href="home.php?a=vestnik" class="showvesnika"><img src="images/stats/vest.gif" border="0" > Весник</a> 
 <a href="home.php?a=addvestnik" class="addvesnika"><img src="images/menu/edit.gif" border="0" > Добави Новина</a> 
 <h3 class='stranicamenu'><center>Вестник</center></h2> 
  
  
  
<?php 
$profile = "home.php?a=profile&id"; 
$query = "SELECT * FROM users WHERE id='$id'"; 
$result = mysql_query($query); 
while($row=mysql_fetch_array($result)) { 
$usersid= ($row['id']); 
} 
?> 
<?php 
$sql = mysql_query("SELECT * FROM `vesnik` order by `id` RAND DESC limit 0,1") or die(mysql_error()); 
$i = 0; 
echo "<table><tr><td>"; 

while($raw = mysql_fetch_array($sql)) { 
$i += 1; 
$zaglavie = ($raw['zaglavie']); 
$content = nl2br($raw['content']); 
$avtor = ($raw['avtor']); 
$id = ($raw['idd']); 
$go1=(mysql_query("SELECT avatar FROM users WHERE name='$avtor'")); 
$avatar=$go1['avatar']; 
echo "<div id='header5'> 
<div><a href=\"$profile=$id\" class='nad'><img src='images/avatar/0.gif' style='width:50px; height:50px;'><br /><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>"; 


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; } 
} 
echo "</td></tr></table>"; 
} 
?>
кажи какво ти показва като сложиш този код :idea:
 
сега показва това а новината не я показва

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RAND DESC limit 0,1' at line 1
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе