sanchez_1960
10-12-2007, 09:54 AM
I want query my db so that it shows the first result of each date. I normally use PHP to filter my results but I don't want to anymore, i'd rather do it the proper way.
CREATE TABLE `images` (
`Image_ID` int(10) NOT NULL auto_increment,
`Image_Name` varchar(50) NOT NULL,
`Image_Link` varchar(200) NOT NULL,
`Image_Type` varchar(15) NOT NULL,
`Image_Date` date NOT NULL,
`Project_ID` int(10) NOT NULL,
PRIMARY KEY (`Image_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
CREATE TABLE `images` (
`Image_ID` int(10) NOT NULL auto_increment,
`Image_Name` varchar(50) NOT NULL,
`Image_Link` varchar(200) NOT NULL,
`Image_Type` varchar(15) NOT NULL,
`Image_Date` date NOT NULL,
`Project_ID` int(10) NOT NULL,
PRIMARY KEY (`Image_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;