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

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and place
I would like to have

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can