load data conditionally

From: Date: Wed, 31 Jan 2001 01:01:56 +0000
Subject: load data conditionally
Groups: php.db 
Request: Send a blank email to php-db+get-6271@lists.php.net to get a copy of this message
Hey there, Can you use the load data infile command to load stuff in only if certain fields match? Or would I have to do this via some php loop? Basically I have a txt file with 5 fields in it. First name, extension, space, seat, cluster. I only wanna update a record with the space seat and cluster information as long as the extension and first name are a match. Thanks! Marky

« previous php.db (#6271) next »