TalkPHP - View Single Post - Comparing string from array with mysql field

ttmtake · 11-29-2010, 09:53 AM

I got something, this checks 2 rows,

PHP Code:


			
$checkDB = mysql_query("SELECT * FROM `table`");
while($row = mysql_fetch_array($checkDB)) { 

      
      $rowCat = str_replace('|','', $row['cat']);
      $rowCity = str_replace('|','', $row['city']);
     
      $cat = array($_POST['cat']); 
      $city= array($_POST['city']); 
      foreach($rowCat as $values){
      foreach($rowCity as $valuez){      
      
          if(in_array($cat, $values) && in_array($city, $valuez)) {
          echo $row['id'];
      }
                                }
                                   }
    }

11-29-2010, 09:53 AM	#2 (permalink)
ttmtake The Wanderer Join Date: Jan 2009 Posts: 8 Thanks: 0	I got something, this checks 2 rows, PHP Code: $checkDB = mysql_query("SELECT * FROM `table`"); while($row = mysql_fetch_array($checkDB)) { $rowCat = str_replace('\|','', $row['cat']); $rowCity = str_replace('\|','', $row['city']); $cat = array($_POST['cat']); $city= array($_POST['city']); foreach($rowCat as $values){ foreach($rowCity as $valuez){ if(in_array($cat, $values) && in_array($city, $valuez)) { echo $row['id']; } } } }