<div>
what &quot;sql&quot; database? MySQL? MS SQL Server? MS Access? ...<br />
what data type is the &quot;Day&quot; field? is there also time portion stored in it?<br />

</div>


<div>
ouch.... I'm sorry about not including that information<br />
<br />
MySQL database<br />
<br />
The data type in 'Day' field doesn't matter, I mean, I just want to see the number of queries. No time will be stored there.
</div>


<div>
You could insert some php code so that every time the page is loaded, it updates a count in a db table.
</div>


<div>
Thanks! &nbsp;I had to code a little bit as you said, but it's perfect, thanks for your help!
</div>


<div>
<div class="content wysiwyg-content">
Hi experts, I have a form in a php page to query a table in SQL.<br />
I'd like to know how many times a table is queried in a day.<br />
<br />
Maybe it could be in a table like this:<br />
<br />
Day | Queries<br />
21-07-08 | 120<br />
22-07-08 | 150<br />
23-07-08 | 110<br />
<br />
Thanks for your help.
</div>
</div>


Hi experts, I have a form in a php page to query a table in SQL.
I'd like to know how many times a table is queried in a day.

Maybe it could be in a table like this:

Day | Queries
21-07-08 | 120
22-07-08 | 150
23-07-08 | 110

Thanks for your help.

How to get total of queries per day ?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.