If Statement Help

jimdy

Anyone know how to use if statement within a query and has successfully executed in php?

I tried queries like these:

IF NOT EXISTS (SELECT AgentID FROM telecom1.Agents WHERE AgentID='ufo0008') SELECT CompanyName FROM telecom1.Agents WHERE AgentID='ufo0008';

IF 'ufo0008' in (SELECT AgentID FROM telecom1.Agents ) SELECT CompanyName FROM telecom1.Agents WHERE AgentID='ufo0008';

Any query that has If in it dont work for me. The query is excuted fine(mssql_query returns 1) but when pass to function like fetch array it give me an error saying the argument is not a valid resource.

I have post this problem few times in database forum but no one seems to know how to solve it

DigitalExpl0it

are you having more than one sql statement?

Are you trying to check and see if a record is already in the database?

jimdy

No they are separate statement I am just trying both to see why If statement dont work for me. Of course there are ways around it I just want to know why if statement dont work.

MeX

i'm not sure for what you need that??

IF 'ufo0008' in (SELECT AgentID FROM telecom1.Agents ) SELECT CompanyName FROM telecom1.Agents WHERE AgentID='ufo0008';

never heard that anybody needs something like that!!

try this; simple and effective 😉:

$query = "SELECT CompanyName FROM telecom1.Agents WHERE AgentID = 'ufo0008'";

$result = mysql_query($query);
if (mysql_num_rows($result)) {
echo "GOT YOU!";
} else {
echo "NO RECORD!!";
}

ceeyaa.MeX

jimdy

thank you for the solution. the query i use is really just for testing purpose. I just find it werid that why a query with if statement dont work in php (it works in sql console).

MeX

hi jimdy!

i've tried to fire some queries like yours in console, but never worked!!

can you tell me where to find this in the documentation or was it your idea to write/try such queries??
i'm now interrested ... maybe we'll find a solution!! 😉

ceeyaa.MeX

jimdy

Hello, I found this problem when I am doing a web project for a company that need to convert their asp code to php code. The query that contains some if statement seem to work with asp but not with php. It does work in my sql console though. very weird.