assining variables in mySQL

sfullman

This is the first time I've tried to do this. ANY AND ALL HELP or pointers would be useful!

in php you can do something like this:

if($x=$someArray['somekey']){
echo "Your value is $x";
}else{
echo "Your value is blank";
}

two things happen, first the var is assigned, and if the assignment is something and not blank, zero, etc., then the var can be used.

I seem to recall that this is accomplished by the use of the @ char in front, but not positive.

One of the things I want to use this for is assigning a part of a complex expression so it doesn't need to be declared through the larger expression, thus making code long and (probably) being a slower query?

Any assistance? Thanks :-)

paulnaj

Hi sfullman,

It's a bit difficult for me to really understand what you're trying to actually do here.

You say -'two things happen, first the var is assigned, and if the assignment is something and not blank, zero, etc., then the var can be used. '

Does the program 'die' if the var is blank, for instance?

Also, it's not necessarily true that shorter code length implies shorter code execution time.

// For example ...
if($a){
    $x = $a;
} else {
    $x = 1;
}

// ... and ...

if($a) $x = $a; else $x = 1;

// ... and ...

$x = $a? $a: 1;

// ... are all equivalent to the compiler

Although I don't always 'practice what I preach', it's probably easier to use the long form every time! In general, it's gonna be easier to read later.

Hope this helps!

Paul.

sfullman

That's not even what I was getting at. How does one assign variables in MYSQL??

these ARE different:
if($x=$someArray['somekey']){
echo "Your value is $x";
}else{
echo "Your value is blank";
}

vs.

if($someArray['somekey']){
echo "Your value is ". $someArray['somekey'];
}else{
echo "Your value is blank";
}

Now, mysql has this function

IF(condition is true, expr1, expr2)

I want to assign a part of the condition as a variable.. not that hard for the one who knows the answer.

Sam

paulnaj

Your first post was essentially gibberish.

I tried to tease some more details from you and help you with some possibilities.

Your second post just confirms that you don't know what you want, even in words.