How to call a function?

Manat

<?php
$sql= "SELECT
CASE WHEN $winners > 25 THEN 'Dothis() 😢'
WHEN MOD((entrantID -10), 98) = 0 THEN 'Dothis2()'
WHEN MOD((entrantID -10), 49) = 0 THEN 'Dothis3()'
ELSE 'Dothis4()'('
END AS WHATEVER

Hello all

I want to know how do I call a function from within this sql code.
Where the Dothis() functions are, I want function calls to be there, but i'm insure where or how to put them as I've never worked with Select Case when clauses before, and the documentation is mostly pseudocode. So how do I do a function call here?

Also, what does the END AS SelectName do? What purpose does it serve?

Last question, are the '(' in the proper places?

Thank
MK

n00854180t

<?php 
$sql= "SELECT 
CASE WHEN $winners > 25 THEN '" . Dothis() . " :'(' 
WHEN MOD((entrantID -10), 98) = 0 THEN '" . Dothis2() . "' 
WHEN MOD((entrantID -10), 49) = 0 THEN '" . Dothis3() . "' 
ELSE '" . Dothis4() . "'(' 
END AS WHATEVER 

?>

You can jump out of the sql query and append your function.

stolzyboy

Don't double post!!

Tis' a rule we have around here, and all it will do is irritate people and cause them to not post in your threads!!

Manat

Oh, I see, great.
Two questions.

1) when I go to DoThis1() for example and in that function there is a redirect, is that ok? I mean it goes to another page and doesn't get the chance to return the to the SQL Select When clause and doesn't reach END AS WTV. Is this fine?

2) End AS WTV. In which scenario would I make use of WTV?

Thanks man
MK

n00854180t

I don't know the WTV command or function or whatnot in mysql. Also, appending that function will only work if it returns a value.

For instance this would work:

function GetBar()
{
echo "bar";
}

mysql_query("SELECT * FROM foo WHERE bar= '" . GetBar() . "'");

but this would not work:

function GetBar()
{
header("Location: http://www.ilikephp.com");
}

mysql_query("SELECT * FROM foo WHERE bar= '" . GetBar() . "'");

Does that help?

Manat

END AS WTV
What I meant by WTV is that whatever value you put after END AS.

So END AS SelectName
What will the value that follows END AS provide?
What can you do with it whether it's WTV or SelectName.
I looked around in MySQL docs sites and found nothing on it.

In the function, I will be doing an Insert Into, and then redirect.

So { sql="Insert into....... value......";

header("Location: http://www.ilikephp.com"); }

So the redirect happens after the Insert Into but doesn't get to END AS.

Thx

n00854180t

I don't know if mysql supports that kind of thing. I don't think it supports sub inserts or selects. (Unless you have version 4.1 alpha) I don't know what to tell you, I am not familiar with the SQL you are using.

Manat

Oh noooo, Sub-Queries, I hadn't thought about that. I guess it's no big deal, I can just architect the flow of my code differently.

But this, I find, is a huge problem with mySQL, it's documentation sucks!

You go to the microsoft site and find an abundance of product related info, and on top of that they are commited to keep upgrading their MSDN/Knowledgebase/technet search engines so you find what you want fast.

Anyhow, I digress.....

Thx
MK

n00854180t

The documentation is not bad. If you want to make more complex scripts go with postgresql. Save yourself the trouble of realizing that you can't make a work around with mysql and switch now. I am having all kinds of headaches trying to fix my project after having to convert.

stolzyboy

i don't know about that, my boss was searching for information about mssql and you go to msdn.microsoft.com and search for mssql, you get crap results, i have always microsoft's support

i agree that MySQL's isn't the greatest, but all the information IS there, it just isn't organized in the best manner

n00854180t

Agreed stolzyboy. I have a better time finding things in the MySQL docs than in the entire MS site. What really makes me annoyed is that MySQL just lacks some of the features that are essential to more sophisticated programs.

stolzyboy

not to start a MySQL v. Postgresql debate, but they are both lacking in their own departments, IMHO, the best thing would be for both of them to suck it up and team up together and they would have the best of the best. But that will NEVER happen, so you just have to choose which one is best suited for your particular situation and keep in mind your clients needs/wants and what they don't want, as in cost, etc...

Manat

Actually, I have never had a problem with MSSQL and I always found my info fast. Try checking out their new search engine, it's been revamped.

Hmm, I thought mySQL was better than progresSQL since not many people use the latter.

NO?

n00854180t

PostgreSQL seems harder to use, but has some features that help some more complex queries I think. I dunno, just stolzyboy said it all depends on what you need.

LordShryku

That's mainly because of the lack of support for Postgres on Windows. I actually prefer Postgres because of it's similarity to Oracle, but when working on a Windows platform, the choice is MySQL. Benchmark testing also shows MySQL as faster, but lacking in features in comparison to PgSQL.

n00854180t

LOL That's the truth, I tried to get PgSQL running on my windows box at home. That was a nightmare. I eventually said screw it and got myself a good SSH host.

LordShryku

I got my hands on one of their old Windows releases, but it just isn't worth it because of how old it is. Then the nightmare of installing through Cygwin made me curl up in the corner in the fetal position and bawl like a lil baby for a couple hours.

stolzyboy

Originally posted by LordShryku
Then the nightmare of installing through Cygwin made me curl up in the corner in the fetal position and bawl like a lil baby for a couple hours.

it's good to know that i'm not the only one to do that

n00854180t

Yeah, I attempted that. I got to the part where it was giving me an error about there not being a compiler in the directory to compile cygipc. So I went to download gcc and went to put it in the directory, and realized I had to install it first. Then I looked at my desktop, saw the thousands of files, and look at my root dir and saw more than 2 folders (which I hate) and I just uninstalled the lot of it. Ugh!

Manat

Hi,

MySQL 3.23.56 is my MySQL version.

Does this version support my SELECT CASE WHEN sql code?
I was unable to find this out on the MySQL Site.

Plz does anyone know the answer to this, and if it doesn't support it, which next version of the version above does support it, and would there be any upgrade issues I should think about?

Thx