id+1

<?php
  $qry = "SELECT id FROM reclame ORDER BY id LIMIT 1";
  $ophalen = mysql_query($qry) or die(mysql_error());
  $obj = mysql_fetch_object($ophalen);

  $id = $obj->id+1;
?>

<?php
  $qry = "SELECT id FROM reclame ORDER BY id LIMIT 1";
  $ophalen = mysql_query($qry) or die(mysql_error());
  $obj = mysql_fetch_object($ophalen);
 
  $id = $obj->id+1;
?>

<?php
  $qry = "SELECT id FROM reclame ORDER BY id LIMIT 1";
  $ophalen = mysql_query($qry) or die(mysql_error());
  $obj = mysql_fetch_object($ophalen);

  if(isset($_POST['submit'])) {
  $id = $obj->id+1;
  $naam = $_POST['naam'];
  $url = $_POST['url'];
  $bannerurl = $_POST['bannerurl'];
  $ip = $REMOTE_ADDR;

  $query="INSERT INTO reclame (id, naam, url, bannerurl, ip) VALUES ('". $id ."', '". $naam ."', '". $url ."', '". $bannerurl ."', '". $ip ."')";
  mysql_query($query) or die (mysql_error());

  echo "Je banner is toegvoegd! <b>Even Geduld!</b>";
  echo "<meta http-equiv='refresh' content='3;url=?pagina=reclamevoegtoe.php'>";
 } else {
?>
Je kan hier gratis een bannerurl van 88×31 toevoegen! Hij komt dan gelijk in het rolatiesysteem.<br>
<br>
<form action='' method='post'>
<TABLE>
<TR><TD>Naam : </TD><TD><input name="naam" type="text" id="naam" maxlength='50'>* <font color="#958C8C">//bv. : Profielweb</font></TD></TR>
<TR><TD>Url : </TD><TD><input name="url" type="text" id="url" maxlength='100'>* <font color="#958C8C">//bv. : http://www.profielweb.nl</font></TD></TR>
<TR><TD>Bannerurl : </TD><TD><input name="bannerurl" type="text" id="bannerurl" maxlength='100'>* <font color="#958C8C">//bv. : http://www.profielweb.nl/images/pwbanner8831.jpg</font></TD></TR>
<TR><TD><input type="submit" value="Voeg Toe!" name='submit'><input type="Reset" value="Leeg Maken!"></TD></TR>
</TABLE>
</form>
<? } ?>

<?php
  $qry = "SELECT id FROM reclame ORDER BY id LIMIT 1";
  $ophalen = mysql_query($qry) or die(mysql_error());
  $obj = mysql_fetch_object($ophalen);
 
  if(isset($_POST['submit'])) {
  $id = $obj->id+1;
  $naam = $_POST['naam'];
  $url = $_POST['url'];
  $bannerurl = $_POST['bannerurl'];
  $ip = $REMOTE_ADDR;
 
  $query="INSERT INTO reclame (id, naam, url, bannerurl, ip) VALUES ('". $id ."', '". $naam ."', '". $url ."', '". $bannerurl ."', '". $ip ."')";
  mysql_query($query) or die (mysql_error());
 
  echo "Je banner is toegvoegd! <b>Even Geduld!</b>";
  echo "<meta http-equiv='refresh' content='3;url=?pagina=reclamevoegtoe.php'>";
 } else {
?>
Je kan hier gratis een bannerurl van 88×31 toevoegen! Hij komt dan gelijk in het rolatiesysteem.<br>
<br>
<form action='' method='post'>
<TABLE>
<TR><TD>Naam : </TD><TD><input name="naam" type="text" id="naam" maxlength='50'>* <font color="#958C8C">//bv. : Profielweb</font></TD></TR>
<TR><TD>Url : </TD><TD><input name="url" type="text" id="url" maxlength='100'>* <font color="#958C8C">//bv. : http://www.profielweb.nl</font></TD></TR>
<TR><TD>Bannerurl : </TD><TD><input name="bannerurl" type="text" id="bannerurl" maxlength='100'>* <font color="#958C8C">//bv. : http://www.profielweb.nl/images/pwbanner8831.jpg</font></TD></TR>
<TR><TD><input type="submit" value="Voeg Toe!" name='submit'><input type="Reset" value="Leeg Maken!"></TD></TR>
</TABLE>
</form>
<? } ?>