RE: [PHP] Probably a mysql problem really, but..

Could you not use the UPDATE isp_auth SET Cvalue='$Cvalue' WHERE reference='$Reference' SQL statement to do it? Seems like it'll achieve what you wanna do a whole lot simpler! - Emile -----Original Message----- From: David VanHorn [mailto:dvanhorn@cedar.net] Sent: 04 July 2000 16:37 To: php-general@lists.php.net Subject: [PHP] Probably a mysql problem really, but.. Here's my problem: MySQL_db_query('database'," REPLACE INTO isp_auth VALUES ('$Reference','$Real_Uname','$Real_Pass','$Created','$Account','$Cvalue')") or die ("Can't replace into ".$Name_Table); Given that the values (especially $Cvalue) are fine, and this statement executes, should I not expect that the 6th field of this entry should contain an updated $Cvalue? The whole point of this is that I've changed $Cvalue, and I want to store that. I think something like this VALUES ('$Reference','','','','','$Cvalue') should work, but I'm not sure. My intent is to pick off the record that begins with the reference field = $Reference, and replace cookie with $Cvalue. -- www.SpamWhack.com A pre-emptive strike against spam A tornado is a lady whose skirts you do NOT want to look up! Where's dave? http://www.findu.com/cgi-bin/find.cgi?kc6ete-9 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net