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

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

Trying to add functions to table
I have this list of characters and I'm trying to figure out what I have to do to put the results of

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

Linux socket programming
Where can I find a good introduction to socket programming?

Preventing SQL Injection
I have a question about SQL Injection, In some of our code we use this: view plaincopy to clipboa

losing session vars when arriving from an email link
Hi,

I've got a confirmation script made that sends an email with a link for a user to confirm

Help pulling in 'id' with "read more" link
I'm trying to create snippets of my articles in the cms I'm creating, and then have them redirect to

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

Search with relational database
Hey,

I have quite a complicated (for me anyway ) relational database for an apartments syste

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this