RE: [PHP-DB] Huw do I perform update? I missed the accual code bi t.. sorry

From:	Andreas D. Landmark	Date:	Thu, 27 Sep 2001 00:07:12 +0000
Subject:	RE: [PHP-DB] Huw do I perform update? I missed the accual code bi t.. sorry
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-12753@lists.php.net to get a copy of this message

At 26.09.2001 19:55, Ricky Theil wrote:

I have no problem updating integer and float fields when putting them in '' if you update an integer with a blank value, it makes the value in the db =0. always on unix and mysql, though. Ricky

True, there's nothing that forces you to wrap integers into "s under mysql, and generally that's not a bad idea, it would escape some of the duuuh-mistakes that happen from time to time....

$query = "UPDATE dvd.news_categories SET newscategory='$newscategory', newscat_status='$newscat_status' WHERE newscat_id='$newsid'";

What does mysql_error() say, and have you tried the query on the command line to get and exact pinpoint where the error is? (okay I admit I haven't even looked at the query as this sounds like a stupid mistake that could be solved by trying a few easy twiddles.) -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then.