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

okuto1973

Again???Not enought one question with one answer?

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

Listen guys,

Just because I posted somewhat the same code doesn't mean my post addresses the same issue.

IF you had read my previous post you would realize that it was mostly about using % vs MOD(), and had nothing to do whatsoever with function calls. Again, just because the code is somewhat the same doesn't mean it addresses the same issue.

And this made no sense to me:Again???Not enought one question with one answer? Could you explain what you mean plz? thx

Even after reading your post I would not go back in time and put this question in the same thread which you speak of because it's a totally different question.

I think moderating forums should require certifications or something, because of issues such as this one, thanks for completely making me digress from my original question, and now ppl might reply to this issue instead of my code question.

stolzyboy

Originally posted by Manat

I think moderating forums should require certifications or something, because of issues such as this one, thanks for completely making me digress from my original question, and now ppl might reply to this issue instead of my code question.
MK

I'm pretty sure I'm capable of moderating the forum, and my education is no concern of yours. And yes, I do have degrees in this field, so that should suffice.

And if you would simply follow the rules, you wouldn't have a problem.

Those posts were so close to the same it was pathetic, if you have code revisions like that keep them in the same post, it will go to the top after you post the code revision, and specify that that is what you are doing, and explain why you made a change.

Also FYI, I cut and pasted the code from these two thread and they are the same.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10255535
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10255533

Also, if you choose edit in your post, and you are the original poster on the original post, there is a delete option, that will delete the whole thread.

Manat

If I had put this question in the previous post, then people would first read my first question thinking that every reply had to do with the same question, and then I ask a different question which makes all the previous reading about the first question futile.

If I was the reader, I would be annoyed and tell the person to put this in a seperate thread, but you did the exact opposite, just goes to show you that only appointed members should act as mods, because every reader has a expectations and interpret certain situations differently.

And no, my two posts weren't the same, which is why their subject headings were different, it's the subject heading, just like emails, that define a post's content.

Please, let it go now, and with all this BS posted after my initial question, thanks to u, I feel like creating another thread because this entire discussion only sways away from the purpose of this post, which has to do with fuction calls.

If you don't agree and you know the answer to my function call question, then just don't post it.

You said: "Those posts were so close to the same it was pathetic, if you have code revisions like that keep them in the same post, it will go to the top after you post the code revision, and specify that that is what you are doing, and explain why you made a change."

No, there you go again, there is no need to specify why I made code changes because it's an entirely different question. Why would I explain why I made code revisions when this should be treated as different code and why I put this in a seperate thread.

Explaining why I made code revisions would have no influence to the answer that would be giving for the question in THIS post.

Thx
MK

stolzyboy

did you even click on those links, they have the same subject and are both in the coding forum

also, whatta mean by only appointed members should be moderators, obviously you haven't noticed: I am a moderator

anyhoo, someone help this poor fella out, and did you take the suggestion in the other post by n00854180t

stolzyboy

this was said in your OTHER "How to call a function" thread

PHP:

<?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.

Manat

Ok stolzyboy,

 Firstly, your right, I hadn't noticed that you were a moderator, sorry for that.

Secondly, it seems that I fell victim to a submit problem. I was reading your post and how they were both in the Coding forum, and I was like what, no the other one is in the database forum.

When you spoke of double posting, I thought you meant this thread in the database forum:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10255310

And I never double posted, but when you said I had two in the coding forum and checked, I saw this:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10255533

So I don't know what happened, and I don't know how the same post got submited twice, which is why I mentioned the subject heading saying they were different.

So i'm confused and I apologize.
Anyhow, thanks.

stolzyboy

No problem.

And sorry for being a such a prick, but it is hard to decide sometimes if someone is purposely double posting or not.

Now that we got that resolved, did that suggestion by n00854180t work or not.

n00854180t

LOL That's what I want to know. Although, this thread was interesting interim reading 😛

stolzyboy

Originally posted by n00854180t
LOL That's what I want to know. Although, this thread was interesting interim reading 😛

Glad we could entertain you for a bit! 😃

n00854180t

Hey stolzyboy, I have noticed that the resolve link doesn't seem to function correctly sometimes. I usually try to mark all my threads resolved, but lately it hasn't been working.

stolzyboy

read this

n00854180t

Oooooh!! Okay, that makes sense. I wondered about that.

Manat

$sql= "SELECT

CASE WHEN $winners > 25 THEN '" . noPrize() . " 😢'
WHEN MOD(($contestantID -10), 22) = 0 THEN '" . prizeA() . "'
WHEN MOD(($contestantID -10), 11) = 0 THEN '" . prizeB() . "'
ELSE '" . noPrize() . "'('
END AS DECISION";

If this is SQL, then where is the FROM tableName?
The line after End AS Whatever"; gives me a php parse error.

After looking I realized there was no FROM, so then i'm thinking, is this even SQL?

Anyone can help me on this?

On my form, after I click on submit, it goes to a php page, and it's blank and just says: Unknown column 'contestantID' in 'field list'

What does that mean, ContestandID is field in my DB.

Manat

Anyone?