I have a simple issue, i don't know where to put the code for edit here is the code that search for data in Mysql DATABASE <?php require_once('config.php'); if (isset($_POST['Search'])) { $id=$_POST['id']; $result = mysql_query("SELECT * FROM filme WHERE id='$id' "); while($rand = mysql_fetch_array($result)) { $x="<b><font color='red'> </font></b>"; echo ' <div id="subtitrare"> <div id="side-head"> <h2><a title="Download Subtitrare '.$rand['nume'].' "> '.$rand['nume'].' </a></h2> </div> <img id="poster" src=" '.$rand['poza'].' " title=" '.$rand['nume'].' "/> <div id="info"> <b>Nume:</b><br> <input type="text" name="nume" size="50" value="'.$rand['nume'].'" maxlength="120"> <br> <b>Tip:</b><br> <input type="text" name="tip" size="50" value="'.$rand['tip'].'" maxlength="120"> <br> <b>An:</b> <br><input type="text" name="an" size="50" value="'.$rand['an'].'" maxlength="120"> <br> <b>Data:</b><br> <input type="text" name="data" size="50" value="'.$rand['data'].'" maxlength="120"> <br> <b>YOUTUBE:</b><br> <input type="text" name="youtube" size="50" value="'.$rand['youtube'].'" maxlength="120"> <br><br> <b>IMDB:</b> <input type="text" name="imdb" size="50" value="'.$rand['imdb'].'" maxlength="120"> <br><br> <b>TEXT:</b> <input type="text" name="www" size="50" value="'.$x.'" maxlength="120"> <br> <b>Comentariu:</b> <br> <TEXTAREA NAME="comentariu" COLS=80 ROWS=15>'.$rand['comentariu'].'</TEXTAREA><br> </div> </div> ' ; } } ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <br>ID:<input type="text" name="id" maxlength="60"><br> <br><input type="submit" name="Search" value="Search"> PHP: and here is the code that should UPDATE the data into the Mysql <? if (isset($_POST['Edit'])) { $enume=$_POST['nume']; $etip=$_POST['tip']; $ean=$_POST['an']; $eyoutube=$_POST['youtube']; $eimdb=$_POST['imdb']; $edata=$_POST['data']; $ecomentariu=$_POST['comentariu']; $id=$_POST['user']; $sql = "UPDATE filme SET nume='$enume', tip='$etip', an='$ean', youtube='$eyoutube', imdb='$eimdb', data='$edata', comentariu='$ecomentariu' WHERE id='$id' "; echo "<br>$id was edited!<p>"; } ?> PHP: but i don't know where to put it ...
i tryed many ways but still can't find what is wrong if i put the update befoare the code like this , still does nothing <?php require_once('config.php'); if (isset($_POST['Edit'])) { $id=$_POST['id']; $enume=$_POST['nume']; $etip=$_POST['tip']; $ean=$_POST['an']; $eyoutube=$_POST['youtube']; $eimdb=$_POST['imdb']; $edata=$_POST['data']; $ecomentariu=$_POST['comentariu']; mysql_query("UPDATE filme SET nume='$enume', tip='$etip', an='$ean', youtube='$eyoutube', imdb='$eimdb', data='$edata', comentariu='$ecomentariu' WHERE id='$id' "); echo "<br>$enume cu $id was edited!<p>"; } if (isset($_POST['Search'])) { $id=$_POST['id']; $result = mysql_query("SELECT * FROM filme WHERE id='$id' "); while($rand = mysql_fetch_array($result)) { $x="<b><font color='red'> </font></b>"; echo ' <div id="subtitrare"> <div id="side-head"> <h2><a title="Download Subtitrare '.$rand['nume'].' "> '.$rand['nume'].' </a></h2> </div> <img id="poster" src=" '.$rand['poza'].' " title=" '.$rand['nume'].' "/> <div id="info"> <b>Nume:</b><br> <input type="text" name="nume" size="50" value="'.$rand['nume'].'" maxlength="120"> <br> <b>Tip:</b><br> <input type="text" name="tip" size="50" value="'.$rand['tip'].'" maxlength="120"> <br> <b>An:</b> <br><input type="text" name="an" size="50" value="'.$rand['an'].'" maxlength="120"> <br> <b>Data:</b><br> <input type="text" name="data" size="50" value="'.$rand['data'].'" maxlength="120"> <br> <b>YOUTUBE:</b><br> <input type="text" name="youtube" size="50" value="'.$rand['youtube'].'" maxlength="120"> <br><br> <b>IMDB:</b> <input type="text" name="imdb" size="50" value="'.$rand['imdb'].'" maxlength="120"> <br><br> <b>TEXT:</b> <input type="text" name="www" size="50" value="'.$x.'" maxlength="120"> <br> <b>Comentariu:</b> <br> <TEXTAREA NAME="comentariu" COLS=80 ROWS=15>'.$rand['comentariu'].'</TEXTAREA><br> <a href="update.php?id='.$rand['id'].'">Update</a> </div> </div> ' ; } } ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <br>ID:<input type="text" name="id" maxlength="60"><br> <br><input type="submit" name="Search" value="Search"> <input type="submit" name="Edit" value="Edit"> PHP: