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

[kriss]

Пробвай така:

<?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")
$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>"; 
} 
?>

или ако не стане така

<?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>"; 

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>"; 
} 
?>

 

[haus]

със първото нищо не става а не се показва нищо а със второто пак грешка

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 1' at line 1

 

[nom3r1]

<?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 RAND() LIMIT 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>";
}
?>

 

[haus]

получи се мерси много