Submit en delete row

Hierbij de php script.

<?
$host = "localhost";
$user = "klanten";
$pass = "klantendat123456";
$db   = "klanten";

$connection = mysql_connect($host, $user, $pass);
mysql_select_db($db);

$number_of_scripts = 1;

//Randomise the table.
$update = "update home set random_order = 999999 * rand(random_order)";
mysql_query($update);
   
//Retrieve from the beginning and the end.
$upper_limit = floor($number_of_scripts / 1);
$lower_limit = $number_of_scripts - $upper_limit;
$select = "(select telefoon, naam, adres, postcode, woonplaats, id, random_order from home order by random_order limit " . $upper_limit . ")" .
          " union " .
          "(select telefoon, naam, adres, postcode, woonplaats, id, random_order from home order by random_order desc limit " . $lower_limit . ")" . 
          " order by random_order";
          
$scripts = mysql_query($select);
$index = 0;
?>
<?php
include('db/db.php');

  $colname_userdata = "0";
  if (isset($_SESSION['MM_Username'])) {
    $colname_userdata = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
  }
  mysql_select_db($database_cms, $cms);
  $query_userdata = sprintf("SELECT * FROM gebruiker WHERE email='%s'", $colname_userdata);
  $userdata = mysql_query($query_userdata, $cms) or die(mysql_error());
  $row_userdata = mysql_fetch_assoc($userdata);
  $totalRows_userdata = mysql_num_rows($userdata);
?>
<script type="text/javascript" src="scripts/popupBox.js"></script>
<center><? while($script = mysql_fetch_assoc($scripts)) { ?>
  <table width="464" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="44%">
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><a href="callto:<?= $script["telefoon"] ?>"><img src="images/bel.png" alt="Bel <?= $script["telefoon"] ?>"></a>&nbsp;<a href="#"><img src="images/ophangen.png" alt="Ophangen"></a>&nbsp;<a href="formulieren/bellen.php" onClick="return show_hide_box(this,160,300,'1px double')"><img src="images/extern.png" alt="Extern Bellen"></a></td>
      </tr>
    </table></td>
    <td width="56%"><b>Ingelogd als :</b> <?= $row_userdata['voornaam'] ?> <?= $row_userdata['achternaam'] ?></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td width="44%" valign="middle">Naam </td>
    <td align="left" valign="middle"><div align="right">
      <INPUT NAME="naam" class="forminput" TYPE="text" VALUE="<?= $script["naam"] ?>" SIZE="43" MAXLENGTH="50" disabled />
    </div></td>
  </tr>
  <tr>
    <td valign="middle">Adres</td>
    <td align="left" valign="middle"><div align="right">
      <input name="naam2" type="text" class="forminput" value="<?= $script["adres"] ?>" size="43" maxlength="50" disabled />
    </div></td>
  </tr>
  <tr>
    <td valign="middle">Postcode</td>
    <td align="left" valign="middle"><div align="right">
      <input name="naam3" type="text" class="forminput" value="<?= $script["postcode"] ?>" size="43" maxlength="50" disabled />
    </div></td>
  </tr>
  <tr>
    <td valign="middle">Plaats</td>
    <td align="left" valign="middle"><div align="right">
      <input name="naam4" type="text" class="forminput" value="<?= $script["woonplaats"] ?>" size="43" maxlength="50" disabled />
    </div></td>
  </tr>
  <tr>
    <td valign="middle">Telefoonnummer</td>
    <td align="left" valign="middle"><div align="right">
      <input name="naam5" type="text" class="forminput" value="<?= $script["telefoon"] ?>" size="43" maxlength="50" disabled />
    </div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td height="20">&nbsp;</td>
    <td><div align="right" valign="bottom">
      <a href="?section=intake&id=<?= $script['id'] ?>&naam=<?= $script['naam'] ?>&adres=<?= $script['adres'] ?>&postcode=<?= $script['postcode'] ?>&tel=<?= $script['telefoon'] ?>&woonplaats=<?= $script['woonplaats'] ?>"><img src="images/start.jpg" alt="Start Intake" align="absbottom"></a>
      <a href="#" onClick="\javascript:window.open('?section=db_start', '_self')"><img src="images/volgende.jpg" alt="Volgende Bellen" align="absbottom"></a> 
      <a href="?section=notitie_toevoegen&id=<?= $script['id'] ?>&naam=<?= $script['naam'] ?>&adres=<?= $script['adres'] ?>&postcode=<?= $script['postcode'] ?>&woonplaats=<?= $script['woonplaats'] ?>&tel=<?= $script['telefoon'] ?>&user=<?= $row_userdata['voornaam'] ?> <?= $row_userdata['achternaam'] ?>"><img src="images/notitie.jpg" alt="Notitie maken" align="absbottom"></a>
	<? 
   	if(isset($_POST['submit'])) { 
      	mysql_query("DELETE FROM home WHERE id=".$_POST['id']); 
   	} 
	?>
      <form method="post"><input type="hidden" name="id" value="<?= $script["id"] ?>"><input class="knop" type="submit" name="submit" style="background-image:url(images/verwijderen.jpg)" alt="Verwijderen" value=""></form>
    </div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<? } ?>

Ps Echt bedankt

het komt een beetje verkeerd in het scherm te staan (-

Dus.. als jij submit word er een rij weggegooid... is het niet verstandiger om wat gegevens te bewaren ofzo?

Ik blijf erbij dat mijn oplossing het netste zou zijn.

das ook zo Arjan

Arjan, bij het toevoegen van jou idee komt deze fout in het mysql

#1064 - 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 '1) DEFAULT '(''y'',''n'')' NOT NULL AFTER `random_order`' at line

dit is tot nu toe de mysql script

CREATE TABLE `klanten` (
`telefoon` varchar(255) NOT NULL default '',
`naam` varchar(255) NOT NULL default '',
`adres` varchar(255) NOT NULL default '',
`postcode` varchar(255) NOT NULL default '',
`woonplaats` varchar(255) NOT NULL default '',
`id` int(11) NOT NULL auto_increment,
`random_order` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1430 ;

gebeld enum('j','n') NOT NULL default 'n',

thanks gozer

nog 1 vraag dan Arjan als je deze wil beantwoorden, hoe verwerk ik nu dan als ik op submit klik dat hij dan automatische dan naar 'y' veranderd ?

echt bedankt voor je goede hulp