Hi,
What I want is to check for empty values for field 2 and put a result
a function instead.
eg :

function func1($val){
return $val.'bis';
}

$query = "UPDATE vals SET val2 = '".func1(`val1`)."' WHERE `val2` IS
NULL";

but the problem is that I can't recover val1 in func1

So, is there a way to do so?
Thanks

steeve_dun@SoftHome.net wrote:
> Hi,
> What I want is to check for empty values for field 2 and put a result
> a function instead.
> eg :
>
> function func1($val){
> return $val.'bis';
> }
>
> $query = "UPDATE vals SET val2 = '".func1(`val1`)."' WHERE `val2` IS
> NULL";
>
> but the problem is that I can't recover val1 in func1
>
> So, is there a way to do so?
> Thanks
>
>

Nope, you can't retrieve the value in an update statement. You'll need
to SELECT the row then process it.

Or check a SQL newsgroup for a way to do it in SQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Nov 7, 2:03 pm, steeve_...@SoftHome.net wrote:
> Hi,
> What I want is to check for empty values for field 2 and put a result
> a function instead.
> eg :
>
> function func1($val){
> return $val.'bis';
>
> }
>
> $query = "UPDATE vals SET val2 = '".func1(`val1`)."' WHERE `val2` IS
> NULL";
>
> but the problem is that I can't recover val1 in func1
>
> So, is there a way to do so?
> Thanks

What do you mean by "can't *recover* vall *in funcl*"?
The first thing that I notice is you use those weirh ` simbols instead
of ' or "". And furhter, "WHERE `val2` IS NULL" also confuses me, why
do you need ` around val2?

$query = "UPDATE vals SET val2 = '" . func1("val1") . "' WHERE val2 IS
NULL";

Maybe I'm missing the point?

Darko

On Wed, 07 Nov 2007 20:58:31 +0100, Darko <darko.maksimovic@gmail.com>
wrote:

> On Nov 7, 2:03 pm, steeve_...@SoftHome.net wrote:
>> Hi,
>> What I want is to check for empty values for field 2 and put a result
>> a function instead.
>> eg :
>>
>> function func1($val){
>> return $val.'bis';
>>
>> }
>>
>> $query = "UPDATE vals SET val2 = '".func1(`val1`)."' WHERE `val2`IS
>> NULL";
>>
>> but the problem is that I can't recover val1 in func1
>>
>> So, is there a way to do so?
>> Thanks
>
> What do you mean by "can't *recover* vall *in funcl*"?
> The first thing that I notice is you use those weirh ` simbols instead
> of ' or "". And furhter, "WHERE `val2` IS NULL" also confuses me, why
> do you need ` around val2?

Standard mysql quoting of database/table/fieldnames (which means you can
use reserved names, normally they are not necessary), allthough the OP
didn't realize that:
- `` means something totally different in PHP
- MySQL cannot use PHP functions during queries
- what string concatination actually is

> $query = "UPDATE vals SET val2 = '" . func1("val1") . "' WHERE val2 IS
> NULL";
>
> Maybe I'm missing the point?

The OP should either use function available in his database, or define a
function in his database if that's more to his liking and supported.

In case of mysql, one might do this:

$query = 'UPDATE vals SET val2 = CONCAT(val1,'bis') WHERE val2 IS NULL';

Allthough the very query screams out there's an error in database design..
--
Rik Wasmus