I want to know if there is a way to make php react to a change from mysql database

example:
I have information on a db and I want to display it in a table and group all the info from one day in one <td></td> then when the day changes, lets say the next day create another <td></td> and so on, just to show the info from different days in different table columns.

in my db I have the data and tree more columns, day month and year,
so if I can separate them by day that would be really sweet.

thanks.

Recommended Answers

All 2 Replies

post your database structure here and it may be possible with just few simple queries for any particular day

`id` int(11) NOT NULL auto_increment,
`ipaddress` varchar(16) NOT NULL,
`year` int(4) NOT NULL,
`month` int(2) NOT NULL,
`day` int(2) NOT NULL,
PRIMARY KEY (`id`)

this is my table, I am trying to make a record of who and when they access the page and putting together everyone who access the same day.

thanks

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.