Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with making code more ‘efficient’
Thanks feherke for your quick and useful response! I have managed to use the code you provided to find the more 'professional' solution that I was looking for. Here's my final bit of code for anyone else who may find it useful: addLoadListener(function() { var n = 10; // number of...- mrcrusoe
- Post #3
- Forum: Javascript
-
Help with making code more ‘efficient’
I have created the following code that selects 10 random images from a selection of 59 without any duplicates. The code works great but as a bit of a newbie to javascript, I’m sure the section where I am checking for duplicates could be made more efficient. I was wondering if anyone could point...- mrcrusoe
- Thread
- Replies: 2
- Forum: Javascript
-
Newbie needs help converting SELECT to DELETE
Thank you so much r937 for this. I had to change INNER JOIN to LEFT JOIN and it worked perfectly! (I must admit it took me some time to work this out but I got there in the end) And yes, I will post all future mySQL posts in forum436, thanks for that. I'm still new to this site but have been... -
Newbie needs help converting SELECT to DELETE
Thanks to Golom and r937 for responding. Unfortunately the suggestions throw up the following errors: DELETE * FROM shoppingbasket WHERE DateAdded < SUBDATE(NOW(), INTERVAL 30 MINUTE) AND NOT EXISTS ( SELECT * FROM shoppingbasket newer WHERE DateAdded >= SUBDATE(NOW(), INTERVAL 30 MINUTE) AND... -
Newbie needs help converting SELECT to DELETE
Hi, I have created the following SELECT statement that works perfectly and retrieves the data I want to work with: SELECT * FROM shoppingbasket WHERE DateAdded < SUBDATE(NOW(), INTERVAL 30 MINUTE) AND NOT EXISTS ( SELECT * FROM shoppingbasket newer WHERE DateAdded >= SUBDATE(NOW(), INTERVAL 30...
