Re: Grab and update values (Was Re: php-db Digest 8 Feb 2004)

It's simple - no need for IF statements, as the SQL Select syntax does that for you ! Try UPDATE tablename

SET     value2=value1,
        value1=0

WHERE value1 > 3 You might also want to look at the REPLACE INTO syntax in the manual too, for completeness. Be aware though that this won't work if you need to do a join, as the join processor cannot know if you have changed a value which it's trying to join on. You may need to use temporary tables in that case. Cheers - Neil. At 00:44 09/02/2004 +0000, you wrote:

Message-ID: <20040208040352.73655.qmail@web41202.mail.yahoo.com> Date: Sun, 8 Feb 2004 15:03:52 +1100 (EST) From: JeRRy <jusa_98@yahoo.com> To: php-db@lists.php.net MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: Re: php-db Digest 8 Feb 2004 01:40:01 -0000 Issue 2250 Hi, I want to grab a value from one table field and place another value in another table fied. So If I had table value1 and it was set to 3 I want to recognise the value 3 and put value 1 in table value2. Example: value1: 3 value2: (blank) So now I need to check value1 and MAKE SURE 3 is the value, if a lower value I want to do nothing. If 3 > than I want to use the value Example 2: value1: 0 (grab 3 and reset to 0, if higher than 3 do the same) value2: 1 (If value1 is 3 > than value 1 needs to go in value2) But how can I achieve this? The queries are ran once a day, no more. So when the query is ran I could than execute the second query to change the value#'s. Would I be right in saying that I'd use a 'IF statement' for this? Or is there another way to do this? I am not sure exactly about executing a query with the IF statement, I do know how to execute a message or HTML information to output to the webpage. I've done some reading online, but have not found what I am requiring ... Could be looking in the wrong place, as usual. All help appreciated. Jerry

======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player. VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.