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?

Other php-forum

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Help with some dates
I have a list of dates in an array:

$mondays = array(
strtotime("October 12, 2009

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

A little help needed passing hidden values to next page
I have a page that has hidden values in a form.

example
Code: <input name='signupID

Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw

links using header()
Hi All

I'm not sure where to ask for help on this but I hope someone can offer some. I'm at

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res