Hi Guys,

I have a table in mysql database called appearances, with an example below of the structure with the variable name at the top



Now as you can see each of the surnames have been saved into a record in the database.

Now what I want to do is create a php piece of code which looks in all the variable names and counts how many times harvey for example has been entered into the database. So it would look through all the variables and nomatter what $shirt variable they are in it will see:

Harvey = 3

and that is incremented every time a new record is added with Harvey in it?

Any ideas please?

Thanks

Chris

How about a while loop running through the rows of data and an if statement checking the values of the variables and incrementing a variable if it's right. Maybe something like below?

PHP Code:


$test_name = "harvey";
$name_count = 0;

include('config.php');

$result = mysql_query("SELCT * FROM appearances");

while ($result_array = mysql_fetch_array($result)) {

$shirtone = $result_array['shirtone'];
$shirttwo = $result_array['shirttwo'];
$shirtthree = $result_array['shirtthree'];

if($shirtone == $test_name) {
     $name_count++;
}

if($shirttwo == $testname) {
     $name_count++;
}

if($shirtthree == $testname) {
     $name_count++;
}

}

print $test_name . " appears " . $name_count . " times."; 


Hopefully that works and actually comes close to solving the problem......

Stoot