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

Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file

Batch Session SM35 stuck in status 'in Background
Hi Experts,

I am facing a problem with Batch Input session SM35.

The batch se

Transaction variant for VA02 not working
My requirement is to have transaction for user to only add the output and print a sales order.

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

random generation
hi

i need help with generating this

numbers from 1-12

i want to generate in ran

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.

I'm using gamecanvas and I was thinking t

Connecion issue
Hi,

For some reason, I keep getting this error when trying to connect:

Warning: mysql_

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put