select countI(D) and switch statement

burna

hy all!

big problem with a select query and switch statement.

all i want is to count a users uploads directly with this select-statement:

	$resultzahl=mysql_query("SELECT count(partnerID) AS zahl, partnerID AS dbpartnerID FROM travel WHERE partnerID = '".$_SESSION['partnerID']."' GROUP BY partnerID ORDER BY zahl DESC ");

problem: if the user doesnt have uploded something the query doesnt fill me the variable $zahl because there comes NO RESULT from the db, not noll, not empty, NOTHING!

the script exits automaticly after the 3rd condition...

then the switch statement should give out the right authorization which depends on the number of uploads from the user ($zahl from db)

switch statement:

switch ($zahl){

case $zahl == 0: 
	$var = "do something"
	break;

case $zahl <= 9: 
	$var = "do something"
	break;

case (10<=$zahl) && ($zahl <=19):
	$var = "do something"
	break;

case (20<=$zahl) && ($zahl <= 29):
	$var = "do something"
	break;

case (30<=$zahl) && ($zahl<= 39):
	$var = "do something"
	break;

case (39<=$zahl) && ($zahl >= 39):
	$var = "do something"
	break;

}

your quick help will be really appreciated!!!!
thanks, burna

mrhappiness

if (mysql_num_rows($resultzahl) == 0)
  $zahl = 0;

hth

burna

thanks for the quick reply, doesnt work. it always stops at the 3rd clause of the switch statement!

is something wrong with my switch statement???

laserlight

You should switch(true), not switch($zahl).

Weedpacket

if($zahl==0)
	$var = "do something";
elseif($zahl<10)
	$var = "do something";
elseif($zahl<20)
	$var = "do something";
elseif($zahl<30)
	$var = "do something";
elseif($zahl<40)
	$var = "do something";
else
	$var = "do something";

seems less likely to have bugs (such as in the last test of the switch, which only succeeds if $zahl is exactly 39, but won't happen anyway, because that case was covered in the previous test).

burna

thank you laserlight!!!

your solution worked perfectly! dont know why my code dont seem to work ( switch($zahl) ).

IT WORKS!!! JIPIIIE!

thanks for all the posts!

the combination from mysql_num_rows and switch(true) worked fine!

greetz,
burna

laserlight

your solution worked perfectly! dont know why my code dont seem to work ( switch($zahl) ).

It works because now you're comparing the boolean result of ($zahl == 0), ($zahl <= 9) etc with the boolean value true.
There would probably be type promotion anyway, but it will fail for when $zahl = 0, since $zahl == 0 is true, but $zahl is false.

the combination from mysql_num_rows and switch(true) worked fine!

You dont need mysql_num_rows(), since you're checking the count.

Anyway, my personal preference is to use what Weedpacket described - good use of if-elseif-else, and reserve switch when you're comparing one variable value with several other possible values, rather than comparing a boolean literal with several other possible expressions that must be evaluated first.

But it's your choice.