Jeg er ved at lave en admin til min side, men kan ikke få det til at virke,
jeg kan godt få date i form, men at bruge update så jeg får de nye date ind
i databasen er ikke noget jeg lige kan
Hvad skal jeg gøre??
Ole
update_bog.php
<?
$db_name = "israelnu";
$table_name = "bog";
$connection = @mysql_connect("localhost")
or die("Couldn't connect.");
$dbs = @mysql_select_db($db_name, $connection) or die("Could'nt select
database");
$sql = "select id, kategori from $table_name
WHERE id = '".$HTTP_GET_VARS["id"]."'";
$result = @mysql_query($sql, $connection) or die("Could'nt execute query");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$kategori = $row['kategori'];
$display_block .= "<FORM ACTION=\"update_bog-do.php\" METHOD=\"POST\">
<table><tr><td>ID: </td><td><INPUT TYPE=\"text\" value=\"$id\" NAME=\"id\"
SIZE=\"8\"></td></tr>
<tr><td>KATEGORI: </td><td><INPUT TYPE=\"text\" value=\"$kategori\"
NAME=\"Kategori\" SIZE=\"50\" MAXLENGTH=\"50\"></td></tr>
</table>
<INPUT TYPE=\"submit\" NAME=\"send\">
</FORM>";
};
?>
<HTML>
<HEAD>
<TITLE> type_Document_Title_here </TITLE>
</HEAD>
<BODY>
Bog update<BR>
<BR>
<? echo "$display_block"; ?>
</BODY>
</HTML>
update_bog-do.php
<?
$db_name = "israelnu";
$table_name = "bog";
$connection = @mysql_connect("localhost")
or die("Couldn't connect.");
$dbs = @mysql_select_db($db_name, $connection) or die("Could'nt select
database");
$sql = "update $table_name set id = id, kategori = kategori
WHERE id = '".$HTTP_GET_VARS["id"]."'";
$result = @mysql_query($sql, $connection) or die("Could'nt execute query");
$display_block .= "
$id $kategori
";
?>
<HTML>
<HEAD>
<TITLE> type_Document_Title_here </TITLE>
</HEAD>
<BODY>
Bog update<BR>
<BR>
<? echo "$display_block"; ?>
</BODY>
</HTML>