Can't Update

Brazil

Hi All!
I've got this problem though i've tried to look at other prevously resolved problems,can't find the answer.
I'm trying to update my table,in my form i've got "edit" button which u press if you want to update.The user will the select the id_no which s/he wants to update and click edit.
After pressing the button it goes to this code below:

if($submit =="Edit")
{
echo '<form action= mydel.php action=post>';
$delete_ids = "'" . implode("','",$id_no) . "'";

$query = "Update details 
  Set  first_name='$first_name'
       ,last_name='$last_name'
       ,tel_no='$tel_no'
       ,fax_no='$fax_no'
  where id_no IN ($delete_ids)";    
$result = mysql_query($query)or 
    die (" echo mysql_error() ");

?>

<h2>Enter New Information You Want To Update With!</h2>

First_name:<input type="text" name="first_name" value="<?php echo $first_name?>"><br>
Last_name:<input type="text" name="last_name" value="<?php echo $last_name?>"><br>
Tel_no: <input type="text" name="tel_no" value="<?php echo $tel_no?>"><br>
Fax_no: <input type="text" name="fax_no" value="<?php echo $fax_no?>"><p>
<input type="submit" name="submit" value="submit"><p>
</form>
<?
echo "Thank You!Your Information Will Be Updated!";

}
Its not giving any errors but it doest display anything in the selected id_no.It does'nt give me the updated record.It prints "Thank You......."; but nothing happens.
What cud be wrong!

laserlight

offhand, maybe you need to use the $_POST array instead of accessing the variables with the assumption that register_globals is On?

laserlight

Thanx for responding!
can u explain how & where must i do that.

You could read:
http://www.php.net/manual/en/reserved.variables.php
http://www.php.net/manual/en/security.registerglobals.php

Brazil

I'm sorry guys but i'm still not answered.

laserlight

I cant be certain of your logic, but:

<?php
//for o/p to html page, textbox or textarea
function prepOut($output) {
	$output = stripslashes($output);
	return htmlspecialchars($output);
}

if ($submit == "Edit") 
{ 
	echo '<form action="mydel.php" method="post">'; 
	$delete_ids = "'" . implode("','",$id_no) . "'"; 

$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$tel_no = $_POST['tel_no'];
$fax_no = $_POST['fax_no'];

$query = "Update details 
Set first_name='$first_name' 
,last_name='$last_name' 
,tel_no='$tel_no' 
,fax_no='$fax_no' 
where id_no IN ($delete_ids)"; 
$result = mysql_query($query)
	OR die(mysql_error()); 

?> 
<h2>Enter New Information You Want To Update With!</h2> 

First_name:<input type="text" name="first_name" value="<?php echo prepOut($_POST['first_name'])?>"><br> 
Last_name:<input type="text" name="last_name" value="<?php echo prepOut($_POST['last_name'])?>"><br> 
Tel_no: <input type="text" name="tel_no" value="<?php echo prepOut($_POST['tel_no'])?>"><br> 
Fax_no: <input type="text" name="fax_no" value="<?php echo prepOut($_POST['fax_no'])?>"><p> 
<input type="submit" name="submit" value="submit"><p> 
</form> 
<? 
	echo "Thank You!Your Information Will Be Updated!"; 
}