Array problems

furious5

I am currently trying to read from an array, and feed this in to an SQL statement.

My problem is that the array, is encoded so for instance the string customer service is passed to SQL as customer+service, which is not returning any results.

Any ideas how I can amend my code to overcome this?


$count=count($industry);
for ($i=0; $i<$count; $i++) { 

// If $industry = all then search all industries
if($industry[$i] == "all"){

if($sql_where != "") { 
$sql_where = $sql_where . "AND "; 

} 

$sql_where = $sql_where . " industry LIKE '%%' "; 

// If $industry is not null but doesn't = all then search the specified industries			

} elseif(($industry[$i]!="") && ($industry[$i]!="all")){

if($sql_where != "") { 

$sql_where = $sql_where . "OR "; 

} 

$sql_where = $sql_where . " industry = '" . $industry[$i]. "' "; 

}		
}

dalecosp

Originally posted by furious5
I am currently trying to read from an array, and feed this in to an SQL statement.

My problem is that the array, is encoded so for instance the string customer service is passed to SQL as customer+service, which is not returning any results.

Any ideas how I can amend my code to overcome this?
$count=count($industry);
for ($i=0; $i<$count; $i++) { 
[/B]

I didn't see anything indicative of the problem... how is the + operator getting into your string? What's before this code ... where is the first appearance of $sql_where? And, probably more important, where's the code that create the $industry array?

FWIW,

 works better than [code] I like that color stuff... :)

dalecosp

Are you urlencode()'ing the $industry variable? Try urldecode()ing it....

🙂