Koerad baasis
';
$queryuserswithcvs = mysql_query('SELECT COUNT(wdb.id), wp.display_name, wp.user_nicename FROM wp_dog_base AS wdb INNER JOIN wp_users AS wp ON wdb.owners_id=wp.ID WHERE wdb.show_cv=1 GROUP BY wdb.owners_id');
if(mysql_num_rows($queryuserswithcvs)!=0){
while($row = mysql_fetch_array($queryuserswithcvs)){
echo '
'.$row['display_name'].' ("nähtavaid" koeri '.$row['COUNT(wdb.id)'].')';
}
} else {
echo '
Hetkel pole andmebaasis ühtegi koera.';
}
echo '';
get_sidebar();
get_footer();
?>