Can any1 tell me what is wrong with this PHP code?

Hello
Can any1 tell me what is wrong with following code :

$row= null;
$dupconp = array();
$dupconb = array();
$dupcone = array();
$dupcona = array();
$dupconr = array();
$qrxyz = mysql_query("SELECT * FROM example");
while ($spdt = mysql_fetch_array($qrxyz))
{
	if($spdt['status']=="statusa")
		array_push($dupconp, $spdt['email']);
	
	else if($spdt['status']=="statusb")
		array_push($dupconb, $spdt['email']);
	
	else if($spdt['status']=="statusc")
		array_push($dupcone, $spdt['email']);
	
	else if($spdt['status']=="statusd")
		array_push($dupcona, $spdt['email']);
		
	else if($spdt['status']=="statuse")
		array_push($dupconr, $spdt['email']);
}	  
 
$statusa=implode(',',$dupconp); 
$statusb=implode(',',$dupconb); 
$statusc=implode(',',$dupcone); 
$statusd=implode(',',$dupcona); 
$statuse=implode(',',$dupconr);

PHP:

"example" table contains following fields :
email (varchar2)
name (varchar2)
status (varchar2)
id (int)
date (date)

Problem :
$statusa, $statusb, $statusc, $statusd, $statuse contains nothing.

Thanks in advance.

 

What do you get if you add a catch-all if inside the loop:

else
echo $spdt['status'];

 

it gives :

statusd
statusa
statusc
statuse
statusd
statusd
statuse
statusa

Code (markup):

 

Really strange!!!

Try to convert each "==" to a strncmp? For example:

if (strncmp($spdt['status'], "statusa", 7) == 0)

Code (markup):

Is there a newline at the end of each value of $spdt['status']? Try to do a "echo strlen($spdt['status'])" to see if it prints 7 or 8.

Good luck!

 

Or try using '===' instead of '=='

 

Are you getting anything if you do
echo count($statusa);