Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. for($i = 0; $i < $count; $i++)
  2. {
  3.     $sql = "SELECT * FROM item WHERE name_of_item LIKE '%$fitem[$i]%'";
  4.     $result = mysqli_query($cxn,$sql)
  5.         or die(mysqli_error($cxn));
  6.     $num_rows = mysqli_num_rows($result);
  7.     $results += $num_rows;
  8.     while($row = mysqli_fetch_array($result))
  9.     {
  10.         $array = array();
  11.         /*
  12.         //testing stuff
  13.         echo "we're in<br/>";  
  14.         echo "<br/>$item[$i] :" . $item[$i];
  15.         echo "<br/> ";
  16.         echo "$row[name_of_item] :" . $row['name_of_item'];
  17.         */
  18.         $mafteach = $row['mafteach'];
  19.         $array[$mafteach]++;
  20.         echo $array[$mafteach];
  21.         echo "<br/>";
  22.         echo $row['name_of_item']. "<br/>";
  23.     }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement