# PHP date change script that calls a database

**URL:** <https://forum.kirupa.com/t/php-date-change-script-that-calls-a-database/66284>\
**Category:** programming\
**Created:** [October 4, 2004, 4:20pm UTC](https://forum.kirupa.com/t/php-date-change-script-that-calls-a-database/66284 "2004-10-04T16:20:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![neiro](https://avatars.discourse-cdn.com/v4/letter/n/ebca7d/32.png) [@neiro](https://forum.kirupa.com/u/neiro)\
**Post date:** [October 4, 2004, 4:20pm UTC](https://forum.kirupa.com/t/php-date-change-script-that-calls-a-database/66284/1 "2004-10-04T16:20:11Z")

</div>

Hello,

I need to create a php script that whenever the date changes it calls the database for that days content.

Does anyone know where I can find a script to do this?

Thanks,

chad

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 4, 2004, 8:29pm UTC](https://forum.kirupa.com/t/php-date-change-script-that-calls-a-database/66284/2 "2004-10-04T20:29:44Z")

</div>

Have a field in the database that has what date it is for, and then do  
mysql\_query(“SELECT \* FROM TABLE WHERE date=$yourDate”);

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 4, 2004, 8:50pm UTC](https://forum.kirupa.com/t/php-date-change-script-that-calls-a-database/66284/3 "2004-10-04T20:50:10Z")

</div>

You’d need to use a cronjob on Unix to do that 🙂 Google it.