updating a mysql record from a php form

ckwall

ok, so i have a record in mysql table:
I want to update it. Obviously if I use:

$query = "INSERT INTO request (assigned_1, assigned_priority, approval) VALUES ('$assigned', '$assigned_priority', '$approval')";

I will get a new record. How would I go about just updating the found record on my page?

stolzyboy

look here

basically

update tablename set fieldname = 'value', fieldname1 = 'othervalue' where fieldnameofidorwhatever = 'whatevervalue'

kevinsequeira

look up the UPDATE statement syntax at http://www.mysql.com/doc/en/UPDATE.html

reg
kevin

pointsplat

blahblahblah is obviously where you want to update it, for example WHERE id=10

$query = "UPDATE request SET assigned_1='$assigned', assigned_priority='$assigned_priority', approval='$approval' WHERE blahblahblah";

ckwall

ok, so I have it all figured out, except for the blablabla part...
I have the page that will be calling the update script displaying multiple records. I have the update button at the end of each record with a few things to select and make changes to.

the uniuqe identifier that I am using is timestamp.

How would I have the script dynamically pull that value from the found record?

pointsplat

im not really sure how you have things set up or what your trying to do, nor do I know if timestamp is a unique identifier. I suppose in theory that should work fine but seems odd to use to me. Either way can you give more detail on what the general thing your doing is, then what you would like the code to do specfically?

Grant

ckwall

what I am doing is grabbing all records that are not yet assigned to a particular value.

the recoed returned will have the value of the timestamp in it.

then the update script would come up... then the script would loop to the next record.

What I would like to do is have this script update only the one record. I would like for it to grab whatever value is appropriate from the found record. This way when the script loos to the next record, the value is unique to that record.

I know this is not comming out clearly.

<?
//Database user info
$username="root";
$password="";
$database="tracker";
$server="localhost";

//Survey Values
$timestamp = $_POST['timestamp'];
$assigned_1 = $_POST['assigned_1'];
$assigned_2 = $_POST['assigned_2'];
$assigned_3 = $_POST['assigned_3'];
$assigned_priority = $_POST['assigned_priority'];
$approval = $_POST['approval'];

//Connect to database
mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

//Insert values from survey_add.htm variable

$query = "UPDATE request SET assigned_1='$assigned', assigned_priority='$assigned_priority', approval='$approval' WHERE timestamp='timestamp'";

//run query variable
mysql_query($query);

//print errors if any on page
echo mysql_error();

//disconnect from the database
mysql_close();
?>

ckwall

any thoughts?
ive tried crap like this as well. I dont know what I am doing.

$query = "UPDATE request SET assigned_1='$assigned', assigned_priority='$assigned_priority', approval='$approval' WHERE timestamp = '" . $timestamp . "'";