bowett

Have you looked at the sleep function: http://php.net/manual/en/function.sleep.php Does that sound like it might do what you want?

Yes, I think the paths have to be relative to the controller file, not the included file.

This is almost definitely a permissions issue. I doubt your host allows remote connections. If it does then have you set the permissions for your user to connect remotely? I would advise against it from a security point of view. If you have to then make sure you limit connections to your IP address and have a strong password.

Part 1: PHP has a built in shuffle method for arrays: http://php.net/manual/en/function.shuffle.php Part 2: You can extract data from an array using a number: $my_array[4] would return the 5th element in the array.

Could you post your table CREATE statements? That way we can more easily visualise what you are trying to do.

You might want to also try LIKE BINARY

From the MySQL manual: SUBSTRING_INDEX(str,delim,count) Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything to the left of the final delimiter (counting from the left) is returned. If count is negative, everything to the right of the final delimiter (counting from the right) is returned. SUBSTRING_INDEX() performs a case-sensitive match when searching for delim. So your query was nearly correct, try this: SELECT id FROM `tablename` WHERE eid LIKE SUBSTRING_INDEX('2020/08/03/2163724v3d0324','/',-3)

You could always try: SELECT * FROM sc_income WHERE full_name = 'Smith, John' AND date >= DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY) Should have the desired effect but not tested it.