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

Switch letters in message (basic cryptology)...
I am trying to switch letters around in a message for an application on my site (see here). The prob

Help Optimizing code
Good Morning,

I wrote a small import function for a website of mine and I know there has to b

Get keys and values from an array
Hellow,

I have an array $Data with keys and values. With a foreach I can display all the valu

Extra fields in main body and php required.
I'm new to PHP so please be gentle. I have a little php script below that works well.
The &quo

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

Query issues
I probably have this setup wrong well I know I do because nothing is showing up now. What I want is

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t