Originally Posted by groogruxking40
Hi all expertz,
I am newly hire intern in web development field and my senior ask me to build mysql query to draw out call history from database.
They want me to build query to get call record of:
3- Last Week
4- this week
Just give me sample code or give me hint. we are working on mobile billing app. Please help me it is very necessary for me because i am a fresh intern. Thanks
if you have a date field in your table, for example created_at or date_created. you can just create a query on that field..
SELECT * FROM calls_table WHERE DATE(date_create) = DATE(NOW())
you play with that query and try to combined some of the MySQL Date functions
to achieve the result you want..