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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.