I got two questions
the first one --> i have this status thing in the site that i'm trying to work with. every time the user sets a new status, the old one she'd previously set will be deleted from the database and it has to stay that way until she submits a new status...I need to code this through php, how do i do it? can anybody show me a snippet please?
the second one ---> I'd been trying to figure this out for more than a month now and it's not working out at all.
I want to automatically assign one or more orderid's from my salesorder table into one and only one employee also found on the same table. Now how do i randomize which employee the orderid goes?'automatically without a person assigning an orderid to an employee' I've already tried "ORDER BY RAND() LIMIT 1" but when i run it on PHP, it doesn't work.
the first one --> i have this status thing in the site that i'm trying to work with. every time the user sets a new status, the old one she'd previously set will be deleted from the database and it has to stay that way until she submits a new status...I need to code this through php, how do i do it? can anybody show me a snippet please?
the second one ---> I'd been trying to figure this out for more than a month now and it's not working out at all.
I want to automatically assign one or more orderid's from my salesorder table into one and only one employee also found on the same table. Now how do i randomize which employee the orderid goes?'automatically without a person assigning an orderid to an employee' I've already tried "ORDER BY RAND() LIMIT 1" but when i run it on PHP, it doesn't work.