Har et update funktion, der ikke opdaterer, men i stedet sletter alt. F.eks ændrer jeg et navn bliver hele navnet slettet i databasen. Er selv helt blank. Har simpelthen ikke kunne finde fejlen. Jeg connecter fint til databasen osv.
Min database er meget simpel:
ID int
SOFTWARE varchar 100
Her er mine 3 scripts.
//content.php//
<?php
include 'mysqlcon.php';
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<?php
while($rows=mysql_fetch_array($result)){
?>
<? echo $rows['id']; ?>
<? echo $rows['software']; ?>
<a href="delete2.php?id=<? echo $rows['id']; ?>">delete</a>
<a href="update.php?id=<? echo $rows['id']; ?>">Edit</a>
<?
}
mysql_close();
?>
//edit.php//
<?php
include 'mysqlcon.php';
$id=$_GET['id'];
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
?>
<form name="form1" method="post" action="edited.php">
<? echo $rows['id']; ?>
<input name="name" type="text" id="name" value="<? echo $rows['software']; ?>">
<input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>">
<input type="submit" name="Submit" value="Submit">
<?
mysql_close();
?>
//edited.php//
<?php
include 'mysqlcon.php';
$sql="UPDATE $tbl_name SET software='$software' WHERE id='$id'";
$result=mysql_query($sql);
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='content.php'>View result</a>";
}
else {
echo "ERROR";
}
?>