pass variable to mysql statement in foreach loop

[phillyrob0817]

Is there a way to use another variable  in a mysql select where statement for inside a foreach loop.

 

Ex:

 

<?php

 

This works fine.

 

    foreach ($range as $b)

            {

 

     $result = $conn->query("select count(*) as mycount1  from $table where date >= '$date' and (Ball1  = $b or Ball2  = $b or Ball3  = $b or Ball4  = $b or Ball5 = $b)");

 

      while ($row = $result->fetch_object()) {

       $count  = $row->mycount1;

       echo  $b." ".$count."<br>";

       }

 

      }

 

 

 

 

But I want to be able to use this variable string  below* in my statement so I can change what comes after the "and" in the statement.

Is there a way to do that?

 

 

    *$ballsB5 = ("Ball1  = $b or Ball2  = $b or Ball3  = $b or Ball4  = $b or Ball5 = $b");

 

 

    foreach ($range as $b)

            {

 

       $result = $conn->query("select count(*) as mycount1  from $table where date >= '$date' and $ballsB5");

 

      while ($row = $result->fetch_object()) {

       $count  = $row->mycount1;

       echo  $b." ".$count."<br>";

       }

 

      }

 

 

 

 

?>

[Barand]

You shouldn't have columns ball1, ball2, ... ballN. You should normalize the data correctly so each ball has its own row - then you have a single column to search.

 

See this thread http://forums.phpfreaks.com/topic/295145-cannot-get-these-variables-to-add-up/?do=findComment&comment=1507842

Edited March 15, 2015 by Barand