Combine different values
Posted: Wed Jul 29, 2009 11:51 am
Hello guys,
I am having following problem: Right now, i take items out of my database with following query:
And just as info, for p=boot
Well, i also use this code for p=browser.
This code gives back items like:
Value Amount
Internet explorer 5.0 6
Internet explorer 6.0 3
Opera 6 2
Safari 2.0 1
Mozilla 5.0 5
Mozilla 6.0 6
...
I actually want to make a global overview, so like:
Internet explorer 9
Opera 6
Safari 1
Mozilla 11
Does anyone know how this is possible? And can I do this already in my query?
Thanks !
I am having following problem: Right now, i take items out of my database with following query:
Code: Select all
<?
$query = "SELECT ".(isset($ssql) ? 'COUNT(value) AS value_count, SUM(count) AS count, value LIKE \'%?%\' AS is_complete, '.$ssql .' AS ' : 'SUM(count) AS count, ')."value, MAX(time) AS time FROM ".$_site['prefix'] . $_table[$_GET['p']]." WHERE ".(isset($subquery[1]) ? $subquery[1] : '1')." GROUP BY ".(isset($ssql) ? $ssql : 'value')." ORDER BY ".$order." ".$by." LIMIT ".(($thispage - 1) * $_config['globallimit']).",".$_config['globallimit'];
//...
while($row = $_DBC->sql_fetch_assoc($query)){
?>
Code: Select all
<?
if($_GET['p'] == "boot"){
$ssql = "SUBSTRING_INDEX(value, '?', 1)";
}
?>
This code gives back items like:
Value Amount
Internet explorer 5.0 6
Internet explorer 6.0 3
Opera 6 2
Safari 2.0 1
Mozilla 5.0 5
Mozilla 6.0 6
...
I actually want to make a global overview, so like:
Internet explorer 9
Opera 6
Safari 1
Mozilla 11
Does anyone know how this is possible? And can I do this already in my query?
Thanks !