When a query returns NULL?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
peperoni
Forum Newbie
Posts: 16
Joined: Thu Jun 15, 2006 10:52 pm
Location: Managua, Nicaragua
Contact:

When a query returns NULL?

Post by peperoni »

Hi u all,

I'm have a query that returns a value NULL when de query is empty, i compare this way:

Code: Select all

$conForo = ConcetarForo();
$sqlForo = printf("SELECT pais_user FROM phpbb_users WHERE username = '%s'", $_SESSION['login']);
$query = mssql_query($sqlForo,$conForo);
$resul = mssql_fetch_array($query);
f ($resul[0] == NULL){
   echo 'Have no Country! ';
}
else{
   echo 'Have country! ';
}
But always print Have no Country! :(. How is the correct way of makin' that comparison if the register is NULL.

Thanks...
User avatar
protokol
Forum Contributor
Posts: 353
Joined: Fri Jun 21, 2002 7:00 pm
Location: Cleveland, OH
Contact:

Post by protokol »

Try calling

Code: Select all

sprintf
instead of

Code: Select all

printf
User avatar
peperoni
Forum Newbie
Posts: 16
Joined: Thu Jun 15, 2006 10:52 pm
Location: Managua, Nicaragua
Contact:

Post by peperoni »

Thanks! :lol:
Post Reply