Tearing my hair out over PHP mysql update script

[bling_bling_vr6]

Name :



Email :



Tel :

[JeniF]

I don't see anywhere in your form the value of 'id'
Place a hidden field in your form to hold this value so the SQL statement will read the value and update.

[bling_bling_vr6]

Hmm, I tried that. I added a hidden field with the called record with the value of id and then tried to pick it up at the beginning of the if statement instead of $id=$_GET[id] i now have $id = $_POST[record]. But still I don't get my record updated. I even tried to see if my variables even receive the $_POST data and they do...I can echo the data out...just can't update it to the db somehow.

[kkeith29]

try this:

<?php

include("connectdb.php");

if(isset($_POST['Submit'])){

$id = $_REQUEST['id'];
$name = $_REQUEST['name'];
$email = $_REQUEST['email'];
$tel = $_REQUEST['tel'];

$sql = "UPDATE phonebook SET name = '" . $name . "', email = '" . $email . "', tel = '" . $tel . "' WHERE id = '" . $id . "'";
$query = mysql_query($sql);

if ($query) {
header("location:select.php");
exit;
}
}

$id = $_REQUEST['id'];

$result=mysql_query("select * from phonebook where id='$id'");

$row=mysql_fetch_assoc($result);

?>

[chmazur]

Did you check the user/passw/database and privileges on your MySQL 5.0 ?

[fatihpiristine]

why do you put ' ' to assign numbers to the variables. it usually gives error.

where id=$id")

[kkeith29]

it has never given me an error