I have got a sql querry which should work on my database. Is should give me a count figure plus the c_mom with the highest count.
$result=mysql_query("SELECT c_mom, count(*) as count FROM $pntable[wars_completed] GROUP BY c_mom ORDER BY count DESC LIMIT 1");
how do i get the amount from count and who the c_mom is.
hope you understand
Lee
