prepare("SELECT fname,mainpic,views,username FROM girls WHERE country=:ckey ORDER by views desc LIMIT 50"); $stmt->bindParam(':ckey',$ckey); $stmt->execute(); echo '
'; while($i3=$stmt->fetch()) { echo '
'; echo ' '; echo '
'; } echo '
'; ?>




registered contestants by name
prepare("SELECT * FROM girls WHERE country=:ckey"); $stmt->bindParam(':ckey',$ckey); $stmt->execute(); while($i3=$stmt->fetch()) { echo ''.$i3["fname"].' '; } ?>