Member Avatar for elamigosam

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.

  • 2 Contributors
  • 2 Replies
  • 81 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by elamigosam
Member Avatar for network18

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

Edited by network18 because: n/a
Member Avatar for elamigosam

`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.