where clause help

[MDanz]

i have imploded the array '$scope'.  i want to put the results into a multiple where clause.  The problem is how do i implement OR into the WHERE clause?

 

		$scopetwo = implode("keywords=",$scope);  


		$getresults=mysql_query("SELECT * FROM message WHERE '$scopetwo' ORDER BY posted ASC",$this->connect);

[Pikachu2000]

Instead of using a string or ORs, you can use IN(). Note the change to the glue in the implode() as well . . .

 

$scopetwo = implode("', '", $scope);
$getresults=mysql_query("SELECT * FROM message WHERE keywords IN ('$scopetwo') ORDER BY posted ASC",$this->connect);

[MDanz]

nvm

[Pikachu2000]

You may want to array_merge() the arrays before using implode. Then you can format the whole thing in one shot. Untested, but this should work.

 

$merged_scopes = array_merge( $scope, $scopepre );
$scopefinal = implode( "', '" ,$merged_scopes );