|
|
Posted by Darko on 11/07/07 19:58
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
Navigation:
[Reply to this message]
|