Opdatering / sletning af data i MySQL
Hej.Vil gerne kunne opdatere/slette nogle data fra min database. Jeg får ingen fejlmeddelelser, hverken når jeg opdatere eller sletter. Der sker bare ikke noget..?? min tabel og mine filer ser sådan ud:
mlink:
mid
mtopkategori
mpunkt
mlink
#mlinkedit#
<?
require("config.php");
$query = mysql_query("SELECT mid, mpunkt, mlink, mtopkategori FROM mlink ORDER BY mid") or die(mysql_error());
while($row = mysql_fetch_assoc($query)) {
echo"
<tr>
<td width=\"100%\">
<p align=\"left\">
<a href=\"http://".$row['mlink']."\" target=\"_blank\"><b>".$row['mpunkt']. "</b></a>
<br>" .$row['mpunkt']. "
<br><a href=\"admin_link.php?id=".$row['mid']."\" target=\"_blank\">Ret/Slet</a>
</p>
</td>
</tr>
";
}
?>
#admin_link#
<?
include('config.php');
if( isset( $_GET['id'] ) )
$id = $_GET['id'];
else
$id = null;
if( $id !== null ) {
$query = mysql_query("SELECT mid, mpunkt, mlink, mtopkategori FROM mlink WHERE mid = '$id'") or die(mysql_error());
$query = mysql_fetch_array($query);
if( $query == null )
die("Fandt ikke linket");
?>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#656565" width="100%" colspan="3"><p align="center"><b><font color="#ffffff">Link opdatering</font></b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1">
<form action="link_edit_ok.php" method="post">
<input type="hidden" value="<? echo $query[id] ?>" name="id">
<tr>
<td>Menu link:</td>
<td><input type="text" VALUE="<? echo"$query[mlink]";?>" name="mlink"><font color="red">*</font></td>
</tr>
<tr>
<td>Menu punkt:</td>
<td><input type="text" VALUE="<? echo"$query[mpunkt]";?>" name="mpunkt"><font color="red">*</font></td>
</tr>
<tr>
<td></td>
<td><br><input type="submit" name="edit_link" value="Opdater">
<br><input type="submit" name="del_link" value="Slet"></td>
</tr>
<?php
}
else {
echo "Fejl";
}
?>
</form>
</table>
</p>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
#link_edit_ok#
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#7a9294" width="100%" colspan="3"><p align="center"><b>Link opdatering</b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<?php
require('config.php');
IF(isset($_POST['edit_link'])) {
$id = $_POST['id'];
$mlink = $_POST['mlink'];
$mpunkt = $_POST['mpunkt'];
if(empty($mlink) OR empty($mpunkt)) {
echo '<font color="red"><b>Fejl!</b></font><br>Felterne markeret med en <font color="red">*</font> <u>skal</u> udfyldes!<br><br>
<a href="index.php?pageid=5"><b>Tilbage</b></a>';}
else {
mysql_connect($mysql_host, $mysql_user, $mysql_pw);
mysql_select_db($mysql_db);
mysql_query("UPDATE mlink SET mlink = '$mlink', mpunkt = '$mpunkt' WHERE mid = '$id'") or die(mysql_error());
echo "Opdateringen af <b>\"$mpunkt\"</b> er gennemført.";
}
}
IF(isset($_POST['del_link'])) {
$id = $_POST['id'];
$mlink = $_POST['mlink'];
mysql_connect($mysql_host, $mysql_user, $mysql_pw);
mysql_select_db($mysql_db);
mysql_query("DELETE FROM mlink WHERE mid = '$id' ") or die(mysql_error());
print "Det valgte link <b>\"$mlink\"</b> er slettet fra databasen.";
}
?>
<br>
<a href="java script:window.close()"><B>Luk</b></a>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
Jeg håber i kan være behjælpelige!
