[RESOLVED] in_array confusion!!

Spudgun

I've been struggling with "in_array" for quite a few hours now so I may not be able to see the woods for the trees. I'm trying to create a random number generator that checks and reads an MSSQL db table to check that the number has not been previously used.

Generating the random number is fine. Writing the data to MSSQL is fine. However, if I query the db table , and then try to compare the list of uploaded codes to see if there is already a record, the in_array function gives me incorrect results even though when doing a print_r I can see a match.

I've tried trimming the array entries to remove whitespace etc, but no joy. Am I doing something really stupid ??

if  (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploaddir . $_FILES['userfile']['name']))
{ 
    $full = " select current_code from dwtest.dbo.tbxnewcatcodes ";
    $fullres = mssql_query($full);
    for($aa=0; $bb=mssql_fetch_row($fullres); ++$aa)
    {
	  $already[] = $bb[0];
	}
	$myfileindex = $uploaddir . $_FILES['userfile']['name'] ;
    $emailaddresses = file ($myfileindex);
    foreach($emailaddresses as $k=>$v)
    {
	  $trimmed = trim($v);
    if(in_array($trimmed,$already))
    {
	  print("Found");
	}
	}
}

The text file I am uploading contains one record that is in the db table and one that is not.

Any help really appreciated.
Thanks

HalfaBee

Have you tried some debugging?

like print_r( $already ) and echo $trimmed ?

Spudgun

Yep - tried print_r on $already and $emailaddresses.
Even done a CTRL + F and searched in IE for the print_r output and there it is.

So - $already contains the variable I'm searching for, but "in_array" won't return that fact...

Really weird.

HalfaBee

in_array() is case sensitive, could that be the problem?

Spudgun

Don't think it can be as my results are all 7 digit numbers....

HalfaBee

a leading zero might cause problems

Spudgun

Can you think of an alternative method to achieve the same outcome ?

TheDefender

I'm confused... Why are you nameing the $emailaddresses, but your output is 7 digit numbers... Also, (just to confirm your intention) what are you specifically trying to accomplish with your trim function?

This is a good alternative. Just looks like you need some tweaking...

Perhaps copy and paste your print_r($already) and a few examples of your $trimmed variables, so we can see a little more about what's going on...

Also, a good way to troubleshoot is to creat a test array, and in it, put a few variables, and basically create what you would expect the $already array to look like... Do the same with a test $emailaddresses array, and Then run your script using static arrays. This will help determine if your code is doing what you expect it to.

Spudgun

Thanks all.
Think I've sorted it now.