# UPDATE command (php/mySQL)

**URL:** <https://forum.kirupa.com/t/update-command-php-mysql/102902>\
**Category:** Uncategorized\
**Created:** [February 28, 2004, 5:40am UTC](https://forum.kirupa.com/t/update-command-php-mysql/102902 "2004-02-28T05:40:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yeldarb](https://avatars.discourse-cdn.com/v4/letter/y/51bf81/32.png) [@Yeldarb](https://forum.kirupa.com/u/Yeldarb)\
**Post date:** [February 28, 2004, 5:40am UTC](https://forum.kirupa.com/t/update-command-php-mysql/102902/1 "2004-02-28T05:40:29Z")

</div>

I need some help in implementing the UPDATE command. I can’t figure out why it isn’t working. The point is to update the values in the database from values submitted in a form. Here’s my code, I would greatly appreciate it if someone could tell me what is wrong with it. I know that it is executing because it prints out the echo.

```php

	if($theName) {
		
	$query = "UPDATE orders SET address='$address', city='$city', state='$state', zip='$zip', phone='$phone', birthdate='$birthdate', lastPresc='$prescDate', lastOrder='$lastOrder', rtBrand='$rtBrand', ltBrand='$ltBrand', rtBaseCurve='$rtBaseCurve', rtDiameter='$rtDiameter', ltDiameter='$ltDiameter', rightPower='$rtPower', leftPower='$ltPower') WHERE username='$theName'"; 
	$result = mysql_query($query);
	
	echo "<i>$theName's data was updated successfully.</i><br><br>";

```