Updating table in php-mysql

Question

i am writing a php code involving mysql. At one point, i have to update a table in my database for which i am using the below 2 statements. But these are not working.

$temp = $row['tracking_id'];  

mysql_query("UPDATE order_products SET state=4.00 WHERE tracking_id = '$temp'");

Note that i don't get an error message. The table is not updated though. Also note, the column names, table names are correct. I have also tried without the single '' quotes around $temp in WHERE clause.

The connection to database is fine. I know this cos select queries are working fine.

Any ideas?

Thanks

did you echo mysql_error(); ? is temp contains the correct value? did you try add '' around 4.00 ? — Dreaded semicolon
– Dreaded semicolon, Commented Aug 29, 2011 at 9:54
Try this echo "UPDATE order_products SET state=4.00 WHERE tracking_id = '$temp'" and paste the answer in mysql command line client. Should give you details of what you are missing — Ravi
– Ravi, Commented Aug 29, 2011 at 9:57

Your Common Sense · Accepted Answer · 2011-08-29 10:13:14Z

3

Try to var_dump temp

var_dump($temp);

and also check errors from your query

mysql_query("UPDATE order_products SET state=4.00 WHERE tracking_id = '$temp'") or trigger_error(mysql_error()." <here is that problem");

It will give you your answer

edited Aug 29, 2011 at 10:13

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

answered Aug 29, 2011 at 9:54

genesis

51.1k20 gold badges99 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nibhrit Over a year ago

Yeah that worked. Looks like someone deleted the table i am working on. The database is on a common server so it took a while to figure that out. mysql_error was great help. thanks

Your Common Sense Over a year ago

Please, don't die! That's both insecure and unusable.

genesis Over a year ago

@Pekka: Ah I'm blind. It definitelly isn't insecure, but unsuable, yes. Thanks for suggestion

Pekka Over a year ago

@genesis the "insecure" bit refers to the fact that the error message is displayed even in production mode, while the assumption is that trigger_error() will not.

Astha · Accepted Answer · 2011-08-29 09:59:37Z

0

Firstly check what is the value in $temp.

If value is fine the do it like this to echo your query.

echo $sql = "UPDATE order_products SET state=4.00 WHERE tracking_id = '$temp'"; $result = mysql_query($sql);

its only for testing and check the query is it fine? try running it directly and see if any error comes

answered Aug 29, 2011 at 9:59

Astha

1,7345 gold badges17 silver badges36 bronze badges

Comments

Daniel · Accepted Answer · 2011-08-29 10:03:53Z

0

How did you fetch the row?

using mysql_tetch_row or mysql_fetch_array?

if you used fetch_array it's not an associative array and you can't do row['something'], only row[index], so use fetch_row instead.

print the value of temp to verify it's ok and if still can't find the problem try using the mysql_error() function to prinT the last mysql error.

answered Aug 29, 2011 at 10:03

Daniel

711 silver badge4 bronze badges

1 Comment

Nibhrit Over a year ago

the row fetch is working fine cos im echo-ing the contents of the row above this statement

Your Common Sense · Accepted Answer · 2011-08-29 10:11:19Z

0

Note that i don't get an error message.

No wonder. You have to ask a database for the error message.

$tmp = mysql_real_escape_string($row['tracking_id']);  
$sql = "UPDATE order_products SET state=4.00 WHERE tracking_id = '$tmp'";
mysql_query($sql) or trigger_error(mysql_error()." ".$sql);
var_dump(mysql_affected_rows); //to see if rows were changed.

if it prints only 0 - then you have a row with exactly same values in your table already

answered Aug 29, 2011 at 10:11

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Collectives™ on Stack Overflow

Updating table in php-mysql

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related