I don't know why can't I update?

Coding show as below:

$con = mysql_connect("example.com","user","password");
if (!$con)
  die('Could not connect: ' . mysql_error());

mysql_select_db("germanpo_gpweb", $con);

 $refnum = $_POST['reference_num'];
 $recetel = $_POST['receiver_tel'];

mysql_query("UPDATE `order` 
 SET `receiver_tel`  = '".$recetel."'
WHERE `reference_num`  = '".$refnum."'");


<p align="center"><? echo "$refnum , $recetel"; ?></p>

I can show $refnum and $recetel value on web page.
And I make sure database table name is order. Two field receiver_tel and reference_num are correct.

Recommended Answers

All 6 Replies

Man, dum da dum, read your private messages! :D

Debug by adding the line

echo mysql_error();

to see what you get.


please add the below line after mysql_query


Let we check

I think your $refnum is comming blank or invalid.
Echo this query and run it in phpmyadmin.

echo $sql = "UPDATE `order` SET `receiver_tel`  = '".$recetel."' WHERE `reference_num`  = '".$refnum."'" ; exit

if reference_num is an int type in your database it will not update because of the tick marks around $refnum.

$sql = "UPDATE `order` SET `receiver_tel`  = '".$recetel."' WHERE `reference_num`  = ".$refnum.";
// lose the ticks ' ' <--

You forgot to add the connection id to the mysql_query, therefore line 15 suppose to be;

mysql_query("UPDATE `order` 
 SET `receiver_tel`  = '".$recetel."'
WHERE `reference_num`  = '".$refnum."'", $con);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.