tæl antallet af ens værdier
Jeg har følgendene Mysql tabel:
id - han_user - han_id - title - content
01 - user3 - 299 - a title - some text
02 - user5 - 299 - a title - some text
03 - user1 - 299 - a title - some text
04 - user1 - 299 - a title - some text
05 - user1 - 197 - a title - some text
06 - user1 - 543 - a title - some text
07 - user3 - 299 - a title - some text
08 - user1 - 299 - a title - some text
09 - user5 - 123 - a title - some text
10 - user5 - 299 - a title - some text
Jeg vil gerne kunne tælle antallet an han_id for hver han_user
user1:
197 = 1
299 = 3
User3:
299 = 2
user5:
123 = 1
299 = 2
Dette er mit script:
<?
include('config.php');
@session_start();
mysql_connect($mysql['host'],$mysql['user'],$mysql['password']) or die (mysql_error());
mysql_select_db($mysql['db']) or die (mysql_error());
$result = mysql_query("SELECT * FROM `contact_module` ORDER BY `time` DESC");
if(mysql_errno() == 1146) {
mysql_query("CREATE TABLE IF NOT EXISTS `contact_module` (
`id` int(11) NOT NULL auto_increment,
`han_user` varchar(255) NOT NULL default '',
`han_id` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;") or die (mysql_error());
echo'The MySQL tabels er now created!<br/>Please <a href="' . $_SERVER['REQUEST_URI'] . '">refresh</a> the page.';
exit;
} else {
include("navigation.php");
echo'<div style="display:none;" id="addNews">
<form method="post" action="contact_scripts.php?action=add&return=' . rawurlencode($_SERVER['REQUEST_URI']) . '">
<table>
<input type="hidden" name="han_user" value="' . $han_cap . '"/>
<tr>
<td><p>HAN id<br><input type="text" name="han_id" style="width:540px;"/></p></td>
</tr>
<tr>
<td><p>Overskrift<br><input type="text" name="title" style="width:540px;"/></p></td>
</tr>
<tr>
<td><p>Besked<br>
<textarea name="content" style="width:540px; height:75px;"></textarea>
</p></td>
</tr>
<tr>
<td style="text-align:right;"><input type="submit" value="Gem" /></td>
</tr>
</table>
<br><br>
</form>
</div>';
//Prints existing news
echo'<table cellspacing="5" width="540" bgcolor="#4f4f4f">
<tr>
<td width="60px"><p><strong>Rediger</strong></p></td>
<td width="40px"><p><strong>Title/ID</strong></p></td>
<td width="200px"><p><strong>Besked</strong></p></td>
<td width="70px"><p><strong>Dato</strong></p></td>
</tr>';
if ($han_cap) {
while($row = mysql_fetch_array($result)) {
if ($row['han_user'] == $han_cap) {
$han_id = $row['han_id'];
$han_id_hex = dechex($han_id);
$color = substr($han_id_hex.$han_id_hex, 0, 6);
$col_num = strlen($color);
echo'<tr>
<td style="background-color:#'.$color.';"><p>
<a href="#" onclick="if(confirm(\'Er du sikker på, at du vil slette?\')) {document.location.href=\'contact_scripts.php?deletethis=' . $row['id'] . '&return=' . rawurlencode($_SERVER['REQUEST_URI']) . '\';}">Slet denne</a><br />
<a href="#" onclick="if(confirm(\'Er du sikker på, at du vil slette?\')) {document.location.href=\'contact_scripts.php?deletehan_id=' . $han_id . '&return=' . rawurlencode($_SERVER['REQUEST_URI']) . '\';}">Slet id</a>
<font color="#'.$color.'">' . $col_num . '</font>
</p></td>
<td style="background-color:#'.$color.';"><p>
<center><p title="' . $han_id . '">' . $row['title'] . '</p></center>
</p></td>
<td style="background-color:#'.$color.';"><p>
' . $row['content'] . '
</p></td>
<td style="background-color:#'.$color.';"><p>
<center>' . strftime("%a %d. %b %y",$row['time']) . '</center>
</p></td>
</tr>';
}
}
} else {
echo'<tr>
<td colspan="4" style="background-color:#6a6a6a;"><p>
Ingen Bruger valgt
</p></td>
</tr>';
echo'
<tr>
<form method="post" action="">
<table>
<tr>
<td><p>Bruger<br><input type="text" name="han_cap" style="width:540px;" /></p></td>
</tr>
<tr>
<td colspan="2" style="text-align:right;"><input type="submit" value="Set" /></td>
</tr>
</table>
</form>
</tr>';
}
echo'</table>';
}
?>