Namen von Liste zu Liste verschieben

[Delphiturbo]

Delphi-Quellcode:

<?php

$server = "xxxx";
$user = "xxxx";
$passwort = "xxxxx";
$datenbank = "xxxxx";


mysql_connect($server, $user, $passwort) or die("keine Verbindung etabliert!");
mysql_select_db($datenbank) or die("Datenbank nicht gefunden!");

$name = $_POST['name'];
$email = $_POST['email'];
$telefon = $_POST['telefon'];
$adresse = $_POST['adresse'];


$q="SELECT * FROM liste1 WHERE name = $name"; //den Datensatz suchen
$result = mysql_query($sql); 

if (mysql_num_rows($query)>0)

{
$line=mysql_fetch_rows($query); 

  $sql="DELETE FROM liste1 WHERE `name`=='" $name . "' LIMIT 1";//Datensatz anhand der ID löschen
 $result = mysql_query($sql); 
  //jetzt in Liste 2 einfügen

  $sql = "INSERT INTO liste2 (name, email, telefon, adresse) VALUES('".$line['name']."','".$line['email']."','".$line['telefon']."','".$line['adresse']."');
  $result = mysql_query($sql)"; // korrigiert 
}



//formular anfang
echo '<form action="#" method="post" name="formular">
<table border="0" align="center">
<tr>
<td></td>
</tr>


<tr>
<td><input type="text" name="name" value="xxxx"></td>
</tr>

<tr>
<td><input type="text" name="email" value="[e-mail]"></td>
</tr>

<tr>
<td><input type="text" name="telefon" value="xxxxxx"></td>
</tr>

<tr>
<td><input type="text" name="adresse" value="xxxxxx"></td>
</tr>



<tr>
<td align="center"><input type="submit" name="submit" value="senden"></td>
</tr>
</table>


</p>
</form>';
//formular ende
?>