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

Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix

form problem
Hi all, I think this is going to be easy to resolve but for I have been looking at it to long and I

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

onclick problem
I have <input type="text" name="message">
<a href=page2.

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

remove a ; from emails in textarea
Code: <?php

session_start();

$database_host = "localhost&qu

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

Career Change into SAP
Hai
I am sajesh ,did my diploma in Mechatronics i have a 4 years of experience in