Delete records not in top 15

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I'm creating a hall of fame page in my game and the page will only display the top 15 scores.
So I want to delete the scores that get bumped down the list.

How would I write the query to delete everything NOT in the top 15?

I've been trying different things, but nothing is working.
I thought maybe something like this, but it didn't work.
Line number On/Off | Expand/Contract $removeold = $db->execute("DELETE FROM `soundoff_hof` WHERE `id` NOT IN (SELECT `id` LIMIT 15 FROM `soundoff_hof`)");

am I close with something like this, or is there another method to do it?

Your Answer:

Login to answer

Other forums

cstdatomic (c++0x std::atomic) / g++ 4.4
Hello,

I'm trying to use cstdatomic (std::atomic in the upcoming c++0x standard) in g++

Inserting a check in checkbox from array value
Hello all,
I have a bit of code that works for a select option box, but does not work for my chec

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..

Collecting AOL Search Terms
I am attempting to collect AOL search terms. I know the code is correct (it works for google, bing,

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

Storing Values taken from a DB...
Using this code it will generate a short list from my database

<?php
mysql_connect

PHP & MS Access - Line Break
Hey Guys!

I'm pulling records from an MS Access database and listing them using PHP and I'm r

Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I canno