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

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve

RadioButtonList data selection
view plaincopy to clipboardprint?

if statements problems
Hi. I'm trying to make a web form, but I kind of hit a dead end trying to figure out why it doesn't

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself