Link to home
Start Free TrialLog in
Avatar of swetha chowdaram
swetha chowdaram

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
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you're new to PHP and need some good "getting started" resources, this article may be able to help.
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
Avatar of swetha chowdaram
swetha chowdaram

ASKER

Need hint or code for achieving this....

My programmer is struggling, but he is not able to do
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial