Member Avatar for hriti

hello every one
please help me out
i want to show my data according to date...
i mean it can be according to current date,previous date
data can be according quaterly month

how to display it from database.

Edited by hriti because: want to add some more
  • 3 Contributors
  • 2 Replies
  • 126 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by jeffey

Recommended Answers

All 2 Replies

Member Avatar for gabrielcastillo

What are the fields of the database? Are you using any kind of timestamp or date field in your database? Can we see some code?

Member Avatar for jeffey

I always use a date field and an updated field

SQL would be "WHERE date = date("Y-m-d");" to get records added today (can use any date)

SQL would be "WHERE updated = date("Y-m-d");" to get records updated today

OR

"ORDER BY date" get all records orderded by date field

Show your query and we can get it working

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.