Forum Moderators: open
New here so hello first of all.
Am having a problem im hoping someone can help with. I have 2 cronjobs running on my site which checks for processes from the top and one from the bottom of the database.
$query = "SELECT * FROM imei WHERE timestamp_receive = '' ORDER BY id DESC LIMIT 0, 300"; The above does work, and even though i have another one using the "ASC" tag i still cant seem to combat all my old requests where as new ones are done with no probs. (confused look)
So i have tried this new code which doesnt seem to make any difference.
$query = "SELECT * FROM imei WHERE status = '2' ORDER BY id DESC LIMIT 0, 300"; When a process is put to us, it has a status "2" once completed it automatically changed to a status "4"
Somehow I need to get the script to check for all status "2" from "imei"
Is there a better way of writing the above? Im new to this so am learning as i go along
Thank you
When you say it doesn't work, how does it fail? Have you tried testing these queries in a database frontend (like phpMyAdmin)?
Often I find that if my database queries look right and behave correctly outside of my PHP code, that the real problem is somewhere else in the code (like the portion that does the updating to mark stuff as "done").