creating a count?

7724

Hi Guys,

Wondering if anyone could help.

I have created a count of 'appearances' everytime the name 'harvey' appears in certain variables in my 'appearances' table:

<?php 

$sql = "SELECT COUNT(*) FROM game WHERE game.shirtone = 'harvey' OR game.shirttwo = 'harvey' OR game.shirtthree = 'harvey' OR game.shirtfour = 'harvey' OR game.shirtfive = 'harvey' OR game.shirtsix = 'harvey' OR game.shirtseven = 'harvey' OR game.shirteight = 'harvey' OR game.shirtnine = 'harvey' OR game.shirtten = 'harvey' OR game.shirteleven OR game.r1 = 'harvey'OR game.r2 = 'harvey' OR game.r3 = 'harvey' OR game.r4 = 'harvey' OR game.r5 = 'harvey' OR game.r6 = 'harvey' OR game.r7 = 'harvey' OR game.r8 = 'harvey' OR game.r9 = 'harvey' OR game.r10 = 'harvey' OR game.r11 = 'harvey'OR game.r12 = 'harvey' OR game.r14 = 'harvey' OR game.r15 = 'harvey' OR game.r16 = 'harvey' OR game.r17 = 'harvey'"; 
$res1 = mysql_query($sql) or die(mysql_error()); 
echo mysql_result($res1, 0); 
?>

I want to modify the code now to look in these variables - ie game.shirtone, game.shirttwo etc in the 'appearances' table, but to look at all the different names that are saved dynamically ie Harvey, Stepford, Higgins and output how many times each name appears in a nice neat table in order of how many times they have appeared = ie:

Can anyone please advise?

Thanks

7724

Hello People,

Bit further on with this if anyone can help?

With this code i'm trying to move stories from a news table to an archive table with exactly the same database structure as each other:

<?php 

// login stuff 

include("../**********.php"); 
include("../**********.php"); 

# if form is submitted..... 
if(isset($_POST['Submit'])) { 
    echo 'form posted succesfully'; 
    echo '<pre>'; 
    print_r($_POST); 
    echo '</pre>'; 
foreach($_POST['d'] as $value) { 
mysql_query("insert into archive select * from news where news.newsid = '$value'; delete from news where news.newsid = '$value'"); 
    } 
} 

# query to get records..... 
    $result = mysql_query("select * from news",$link) or die(mysql_error()); 

?> 


<body bgstyle="color:#FFFFFF"> 
<form name="form1" method="post" action="">
  <table width="100%" cellpadding="1" cellspacing="1" bgstyle="color:#999999"> 
  <tr bgstyle="color:#CCCCCC"> 
    <td width="6%" valign="middle"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font><span class="brown_bold">No:</span></td> 
    <td width="94%" valign="middle" class="light_blue"><b class="blue_bold">News 
      Story:</b></td> 
  </tr> 
  <?php 
  #loop through the rocord 
  while($row = mysql_fetch_array($result, MYSQL_BOTH)){ 
?> 
  <tr bgstyle="color:#FFFFFF"> 
    <td width="6%"> 
      <input type="checkbox" name="d[]" value="<?php echo $row['newsid'];?>"> 
    </td> 
    <td width="94%"><a href="news.php?newsid=<?php echo $row['newsid']?>"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row['headline'];?></font></a></td> 
  </tr> 
  <?php 

}?> 
  <tr bgstyle="color:#FFFFFF"> 
    <td width="6%">&nbsp;</td> 
    <td width="94%"> 
      <input type="submit" name="Submit" value="Send to Archive" class="button"> 
    </td> 
  </tr> 
</table> 
</form>
</body> 
</html>

It's being strange and thowing this up when I try to move a story:

...and the [0] => 1 changes to [0] => 2 etc depending on what story I try to move.

Trouble is it says 'form posted succesfully', but it has not...

Any ideas?

Thanks