[Resolved] UPDATE can't get sql right.

[skeetley]

This is my first try at an UPDATE sql statement for my database.

This is an example of the PHP code phpmyadmin gives when I did a real update:

$sql = 'UPDATE `RTS_Updates` SET `Comment` = \'Put in Energizer battery..\' WHERE `FMFP_ID` = \'PINEH\' AND `Date_Valid` = \'2004-04-14\' AND `Comment` = \'Put in Energizer battery\' LIMIT 1 ;'
        . ' '; 

But in the place of Put in Energizer battery.. should be what is in the $Comment_new string that is passed from the form. In the place of PINEH should be $FMFP_ID, in the place of 2004-04-14 should be $Date_Valid and finally in the place of Put in Energizer battery should be $Comment_old.

How do I set this up properly? Many thanks.

[devinemke]

assuming you form method is POST:

$sql = "UPDATE RTS_Updates SET
Comment = '" . $_POST['Comment_new'] . "' WHERE 
FMFP_ID = '" . $_POST['FMFP_ID'] . "' AND 
Date_Valid = '" . $_POST['Date_Valid'] . "' AND 
Comment = '" . $_POST['Comment_old'] . "' LIMIT 1";