Update a Record

// Send data to db
$query = "UPDATE vehicles
          SET vin = '$vin',
              title = '$title',
              cost = '$cost',
              year = '$year',
              make = '$make',
              model = '$model',
              dateOfPurchase = STR_TO_DATE('$dateOfPurchase','%m/%d/%Y'),
              bodyNumber = '$bodyNumber',
              transmissionSN = '$transmissionSN',
              engineSN = '$engineSN',
              knownAs = '$knownAs',
              dateOfRemoval = STR_TO_DATE('$dateOfRemoval','%m/%d/%Y'),
              isInFleet = '$isInFleet'
          WHERE tag = '$tag' AND state = '$state'";
$result = mysql_query($query);
if (!$result || mysql_affected_rows() < 1) {
  $status_message = 'Problem with user data entry';
} else {
  $status_message = 'Successfully edited user data';
}
Advertisements

About samehramzylabib

See About on https://samehramzylabib.wordpress.com
This entry was posted in Coding, Database and tagged , , . Bookmark the permalink.

Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s