function in mysql query

[steeve_dun]

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

[Jerry Stuckle]

st********@Soft Home.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.
js*******@attgl obal.net
=============== ===

[Darko]

On Nov 7, 2:03 pm, steeve_...@Soft Home.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

[Rik Wasmus]

On Wed, 07 Nov 2007 20:58:31 +0100, Darko <da************ **@gmail.com
wrote:

On Nov 7, 2:03 pm, steeve_...@Soft Home.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,'bi s') WHERE val2 IS NULL';

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