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?
Streaming local file from PHP while it’s been written to by a CURL process
I am creating a simple Proxy server for my website. Why I am not using mod_proxy and mod_cache is a different discussion. Here's the code: shell_exec("nohup curl --create-dirs -o {$write_path}
how to timeout $doc = new DOMDocument()->load($url)
I am currently using this $doc->load($url) to fetch an rss feed.If a feed takes long than 20 seconds to download, I wish to terminate it and proceed to the next, is there any way of terminating
Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do delete on all indexes, but my question is that if I just clear the vector. Are the pointers
question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.I have roughly 30 files. I want to be able to edit every $_POST and $_GETCode:
Issue Parsing XML into table
Hello all,Im a bit new to php and new to phpfreaks. But thanks in advance for the help!Im parsing an xml feed into a table. The only problem is that one of the fields can not format properly in the
PHP Array quick help
I need$_SESSION{'username'} to be like this:if $_SESSION['username'] = "gayner,bob,jesus";echo "ba blah ";but do i use Arrays or what for those 3 nameS? how thanks
Add "width" check when upload
Hi!Can someone add a function that is checking if picture witdh is bigger then 800px whwn uploading, then echo "image oversized" to the code below?Code: <?php ###/ VARIABLES -
ASP.NET Validation Event Cycle
Hi,I have asp button as follow:<asp:Button id="btnTest" OnClientClick="SetSomething(true);" ValidationGroup="A" OnClick="btnTest_Click" />The event flow is like this,1. OnClientClick Event is
reading partial code from external site
Hi,I am trying to write a script for my website to get an article from an external website. The external website has the article in a set of tags <roottag> &
Sort Alternative/bi-monthly
Hi all,Am going mad trying to get something to work. I'm creating a CMS for a magazine. The magazine is published every 2 months and therefore the edition is nov-dec or jan-feb etc.I've an archive
