Forum PHP.pl

[PHP] pobierz, plaintext 
$query = mysql_num_rows(mysql_query('SELECT `id` FROM `ogloszenia`'));
  $id = rand(1, 2000);
  mysql_query(" DELETE FROM ogloszenia WHERE id=".$query['id']." ") or die (mysql_error());
  mysql_query("INSERT INTO `ogloszenia` (`text`, `id`) VALUES ('".htmlspecialchars($_POST['text'])."', ".$id.")") or die (mysql_error());
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if (isset($_GET['step']) && $_GET['step'] == 'ogloszenie')
{
if (isset($_POST['add']))
{
if (!empty($_POST['text']))
{
$_POST['text'] = nl2br($_POST['text']);
$data = date("Y-m-d");
 
$query = mysql_num_rows(mysql_query('SELECT `id` FROM `ogloszenia`'));
  $id = rand(1, 2000);
  mysql_query(" DELETE FROM ogloszenia WHERE id=".$query['id']." ") or die (mysql_error());
  mysql_query("INSERT INTO `ogloszenia` (`text`, `id`) VALUES ('".htmlspecialchars($_POST['text'])."', ".$id.")") or die (mysql_error());
  echo '<br><br><center> <font color=green>Ogłoszenie Dodane</font></center>';
}
else echo '<br><br><center> <font color=red>Wypełnij Pola</font></center>';
}
else echo '
 
<br><br>
<form method="post" action="admins.php?step=ogloszenie#add">
Dodaj Ogłoszenie:<br /><br />
<table>
<tr><td> Tekst: <textarea name="text" rows="15" cols="60" tabindex="3"></textarea></td></tr>
<tr><td> <input type="submit" name="add" value="Dodaj"></td></tr>
</table>';
 
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
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 '' at line 1
[PHP] pobierz, plaintext