asked on
Need PHP code for the below mysql query
SELECT id userid max(checktime) FROM adms_db.checkinout where checktype = 1 group BY DAY (checktime),userid
SELECT * FROM adms_db.checkinout where checktype = 0 GROUP BY DAY(checktime),userid
Basically Im trying get attendance report users.
main tables:
checkinout
userinfo
departments
PHP 5.6
MySQL
database: adms_db
root
no password
SELECT * FROM adms_db.checkinout where checktype = 0 GROUP BY DAY(checktime),userid
Basically Im trying get attendance report users.
main tables:
checkinout
userinfo
departments
PHP 5.6
MySQL
database: adms_db
root
no password
PHPMySQL ServerHTML
Last Comment
Dave Baldwin
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Need hint or code for achieving this....
My programmer is struggling, but he is not able to do
My programmer is struggling, but he is not able to do
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html
If you're experienced with PHP and just need some MySQL guidance, this article has examples that map the various ways of using the MySQL extensions (both old and new).
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html