Mysql .....

Code: PHP

<?php

if($submit)

{

$db = mysql_connect($db_host, $db_user, $db_passwd);
mysql_select_db($db_name, $db);

$result = mysql_query("UPDATE g2_forum SET (titel, name, email, text) VALUES ('$titel', '$name', '$email', '$text') where id='$id'"); 

if($result!=1)

{

echo "Es ist ein Fehler aufgetreten !<br>";

}

}

else

{

echo "<form method=post action=Edit.php?id='$id'>";

$db = mysql_connect($db_host, $db_user, $db_passwd);
mysql_select_db($db_name, $db);

$result = mysql_query("SELECT * FROM g2_forum where id='$id'", $db);

while ($myrow = mysql_fetch_array($result)) {

echo "Thread Name:<br><br>";

echo "<input type=Text name=titel size=20";

printf (" value=%s> <br> <br>",$myrow["titel"]);

echo "Name:<br><br>";

echo "<input type=Text name=name size=20";

printf (" value=%s> <br> <br>",$myrow["name"]);

echo "Email Adress:</p></td>";

echo "<input type=Text name=email size=20";

printf (" value=%s> <br>   </td>",$myrow["email"]);

echo "<br>Text:<br><br>";

echo "<TEXTAREA NAME=text COLS=60 ROWS=5>";

printf ("%s",$myrow["text"]);

echo "</TEXTAREA> <br>  </td>";

?>

<input type="Submit" name="submit" value="Edit Thread" style="float: right"></td>

</form>

<?

}

?>

<?

}

?>