MySQL selection...
Posted: Tue May 31, 2005 8:04 pm
If i am selecting fields from a table, but for example, some are
index.php?pg=2334, some are index.php?pg=2334&PHPSESSID=WHATEVER
Returns each with their respective counts.
However, I want to be able to split off the PHPSESS so that equal pages with a phpsessid count as the same. Can i remove the phpsess in the sql string?
index.php?pg=2334, some are index.php?pg=2334&PHPSESSID=WHATEVER
Code: Select all
$sql = "SELECT `Page`, COUNT(`Page`) FROM `Visitors` GROUP BY `Page`";However, I want to be able to split off the PHPSESS so that equal pages with a phpsessid count as the same. Can i remove the phpsess in the sql string?