Hjælp til at slette i Mysql
Kære eksperter, jeg har et stort problem, der er fejl et par steder i mit script, og jeg er ikke ligefrem den bedste til php, så håber i måske lige kan rette det lidt igennem for det er meget vigtigt det snart er klar desværre.<?php
ini_set('error_reporting', "E_ALL");
require("conn.php");
?>
<div align="center" class="tekst_normal">
<p><br>
<?php
if(isset($_GET["id"]))
{
mysql_query("DELETE FROM ftc_ann WHERE id='". $_GET["id"] ."'") or die(mysql_error());
echo "<b><font face=Verdana size=1>Varen blev slettet!</font></b><br><br>";
}
echo "<table>\n";
$res = mysql_query("SELECT * from ftc_ann ORDER BY id DESC LIMIT 0, 100");
while($row = mysql_fetch_array($res))
{
<table width="100%" border="0" cellpadding="0" cellspacing="0" height="106">
<tr>
<td height="29" rowspan="2"> <b><br>
<a href="?id=$row%5Bid%5D">Slet</a></b> <a href="redig_ann.php">Rediger</a></td>
<td height="29" rowspan="2" width="9%">
<div align="center"><img src="<?$row[upfile]?>" width="81" height="78"></div>
</td>
<td height="14" width="13%"><b>Brugernavn:</b></td>
<td height="14" width="13%"><b>Navn:</b></td>
<td height="14" width="13%"><b>Email:</b></td>
<td height="14" width="14%"><b>Telefon:</b></td>
<td height="14" width="16%"><b>Adr:</b></td>
<td height="14" width="15%"><b>Tekst:</b></td>
<td height="14" width="15%"><b>Pris:</b></td>
</tr>
<tr>
<td height="15" width="13%">
<div align="center">
<?$row[bruger]?>
</div>
</td>
<td height="15" width="13%">
<div align="center">
<?$row[navn]?>
</div>
</td>
<td height="15" width="13%">
<div align="center">
<?$row[email]?>
</div>
</td>
<td height="15" width="14%">
<div align="center">
<?$row[tlf]?>
</div>
</td>
<td height="15" width="16%">
<div align="center">
<?$row[adr]?>
</div>
</td>
<td height="15" width="15%">
<form name="form2" method="post" action="">
<textarea name="textfield" cols="30" rows="5"><?$row[tekst]?></textarea>
</form>
</td>
<td height="15" width="15%">
<div align="center">
<?$row[pris]?>
</div>
</table>";
echo "</tr></td>\n";
}
echo "</table>"; ?>
<br>
<br>
</p>
</div>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0" height="106">
<tr>
<td height="29" rowspan="2"> <b><br>
<a href="?id=$row%5Bid%5D">Slet</a></b> <a href="redig_ann.php">Rediger</a></td>
<td height="29" rowspan="2" width="9%">
<div align="center"><img src="<?$row[upfile]?>" width="81" height="78"></div>
</td>
<td height="14" width="13%"><b>Brugernavn:</b></td>
<td height="14" width="13%"><b>Navn:</b></td>
<td height="14" width="13%"><b>Email:</b></td>
<td height="14" width="14%"><b>Telefon:</b></td>
<td height="14" width="16%"><b>Adr:</b></td>
<td height="14" width="15%"><b>Tekst:</b></td>
<td height="14" width="15%"><b>Pris:</b></td>
</tr>
<tr>
<td height="15" width="13%">
<div align="center">
<?$row[bruger]?>
</div>
</td>
<td height="15" width="13%">
<div align="center">
<?$row[navn]?>
</div>
</td>
<td height="15" width="13%">
<div align="center">
<?$row[email]?>
</div>
</td>
<td height="15" width="14%">
<div align="center">
<?$row[tlf]?>
</div>
</td>
<td height="15" width="16%">
<div align="center">
<?$row[adr]?>
</div>
</td>
<td height="15" width="15%">
<form name="form2" method="post" action="">
<textarea name="textfield" cols="30" rows="5"><?$row[tekst]?></textarea>
</form>
</td>
<td height="15" width="15%">
<div align="center">
<?$row[pris]?>
</div>
</td>
</tr>
</table>
Håber virkelig i lige vil tage jer lidt tid at hjælpe mig.
Mvh. Trevi ApS
