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

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

Echo multiple lines of html code
Hi guys,

I would like to know if there is a way to echo multiple lines of html codes.

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl