Re-update problem

ngu_tri

Hi everyone. I try to do some complicated update. I already inserted many records. I display all records and once I click at "Tittel_id" that displays old details inside the text fields of the update form, and then I want to change content inside the text fileds. Finally new update. Hope you understand what i mean. Thanks

1)display.php (shows all records and underlines link at Tittel_id)

<?php include("dbconnect.php"); ?>
<?php
$result = mysql_query("select * from media where Tittel_id=Tittel_id");
if ($result)
{
while ($row = mysql_fetch_array($result))
{
$id=$row["Tittel_id"];
print "Tittel_ID:";
print "<a href='oppdate_action.php? Tittel_id=$id'>$id</a>";
print " \n";
print "Tittel:";
print $row["Tittel"];
print " \n";
print "Medium:";
print $row["Medium"];
print " \n";
print "Sjanger:";
print $row["Sjanger"];
print " \n";
print "Produsent:";
print $row["Produsent"];
print " \n";
print "Publisert:";
print $row["Publisert"];
print " \n";
print "Starttid:";
print $row["Starttid"];
print " \n";
print "Varighet:";
print $row["Varighet"];
print " \n";
print "Rettighetshaver:";
print $row["Rettighetshaver"];
print " \n";
print "Fag:";
print $row["Fag"];
print " \n";
print "Trinn:";
print $row["Trinn"];
print " \n";
print "Tale:";
print $row["Tale"];
print " \n";
print "Teksting:";
print $row["Teksting"];
print " \n";
print " \n";
print " \n";
}
mysql_free_result($result);
}

?>

2) new_update_form.php (change content inside the text fields of the update form)

GOT PROBLEM HERE

<?php include("dbconnect.php"); ?>

Tittel:
<input type=text size=40 name=tittel value=
<?php
$opp=$_GET["Tittel_id"];
$result=mysql_query("SELECT Tittel FROM media WHERE Tittel LIKE '%$opp%'");
echo "$result";
?>>
 
.....
....
....

....

3) final_update.php (new updated after changing)
<?php
$tittel=$_POST["tittel"];
update media where('$tittel','','','');
?>

new update is sucessfull.

mourisj

What problem do you get ????

I already suggest to do the following:

$opp=$_GET["Tittel_id"];
$qry = "SELECT Tittel FROM media WHERE Tittel LIKE '%$opp%'";
$result=mysql_query($qry);

This avoids trouble with interpreting variables inside an sql statement.

Best regards,

JJ Mouris