getting most records by count

Posted on 16th Feb 2014 07:03 pm by admin

Code: [Select]<?php

$connect = mysql_connect("localhost","damgears_evil","damgears");
mysql_select_db("damgears_evil");
$queryreg = mysql_query("SELECT COUNT(*) FROM titles WHERE fname = '$fname' && lname = '$lname' ");
while($row = mysql_fetch_assoc($queryreg))
{
$amountitles = $row[0];
$dbname = $row['fname'];
echo "$amoutitles $dbname";
}
?>


Basically what i want to do is if ther is a record

Jeff Smith
Jeff Smith
Jeff Smith
John Adams
John Adams
Susan Adams
Jeff Smith

I want it to count it and order it by count so the person with the highest amount of records then displays

$amounttitles - $dbname

and limit to top 10.

thanks

Your Answer:

Login to answer

Other forums

Troubles with a spider class
I am building a spider that will crawl through random whitepages (eg. anywho.com, switchboard.com, w

Calculus Help (and by help I mean homework)
Hrmmm, I hate posting about math homework, partly because it's homework, and partly because I hate w

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
error help - Dynamic Image 
I've been working on making my site less cluttered in the directories and more secure lately.  In an
Undefined index: username HELP NEWBIE 
I am trying a simple login/logout for my website. It works well with checking if the username exists
generating random codes 
Hi guys n gals,

I have a requirement to generate 250,000 unique codes...

These codes a
need help in dynamic select menu in php 
hi i have created a dynamic select menu using php. i have a problem in that which is when the user s
Easy administration on MySQL databases 
My website is database driven and I am very tired of manually making queries to my tables in order t
Uploading Filetypes and placing them in seperate folders.  
Hello, 

first post , and asking for help im afraid. Very new to PHP, was making good progress
form problem 
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for