CODEWITHSUNDEEP
phpmysqlloops
Julian Paolo Dayag
Julian Paolo Dayag

Reputation: 3739

php Mysql query in a while loop

I'm new to php and i don't have the formal study, since i study it myself i have a problem and i hope someone can help me.. :(

I have and array

$array = array("where","are","you" and so on.....);

and i want to search the database with all those values

like 

$sql_res1 =mysql_query("select * from lady_vega where react like '%$array[0]%'");  
$sql_res2 =mysql_query("select * from lady_vega where react like '%$array[1]%'");  
$sql_res3 =mysql_query("select * from lady_vega where react like '%$array[2]%'");

.... and so on

there are times that the array don't have the exact number of values.

and someone said to me that loop could be a help...
but i don't know how...

and i also want the results of each mysql query will be stored like this so that i can i dentify which results are from... 

$row1  = mysql_fetch_array($sql_res1);  
$row2  = mysql_fetch_array($sql_res2);  
$row3  = mysql_fetch_array($sql_res3);

... so on

i hope there would a possible solution/technique to this..

Upvotes: 1

Views: 1946

Answers (3)

Taha Paksu
Taha Paksu

Reputation: 15616

$sql = "";
for($i=0;$i<count($array);$i++){
    $sql.="select *,'".$array[$i]."' as keyword from lady_vega where react like '%".$array[$i]."%'";  
    if($i!=count($array)-1) $sql .= " union ";    
}

$result = mysql_fetch_array(mysql_query($sql));

$last_keyword="";
$index = 1;
foreach($result as $row){
    if($last_keyword!=$row["keyword"]){ 
        $index++;
        ${"row".$index} = array();
    }
    array_push(${"row".$index},$row);
}

then you'll get the same result with an extra "keyword" column.

Upvotes: 0

user1170392
user1170392

Reputation:

You could try using a foreach loop for example.

$terms = explode(",",$array);

$query = "select * from lady_vega where ";

foreach($terms as $each){
    $i++;
    if($i ==1){
    $query.="react LIKE '%$each%'";

    }
    else
        $query .= "OR react LIKE '%$each%' ";


    }

Upvotes: 0

Ben Rowe
Ben Rowe

Reputation: 28721

Try using the following:

$sql = "select * from lady_vega where react like '%".implode("%' OR react LIKE '%", $array)."%'"
$sql_res1 =mysql_query($sql);

You can chain multiple where clauses using OR and AND in your query:

WHERE field = 'value' AND field2 = 'value'

Upvotes: 2

Related Questions