welch Posted November 5, 2007 Share Posted November 5, 2007 I have created a batch record table batch_payment -> id -> date -> name -> detail With this basic setup, i am lost how I can setup a limit within the array to display only 1 date of the list. So if I had 8 payments on jan. 1st and 10 on jan 2nd, it won't display jan 1st 8 times and jan 2nd 10 times, but rather just show each date once. Any ideas? Link to comment https://forums.phpfreaks.com/topic/76006-data-qrray-with-limitless-entries/ Share on other sites More sharing options...
teng84 Posted November 5, 2007 Share Posted November 5, 2007 you need to use group by clause and this is no php this is SQL select * from table group by yourdate etc... Link to comment https://forums.phpfreaks.com/topic/76006-data-qrray-with-limitless-entries/#findComment-384711 Share on other sites More sharing options...
welch Posted November 5, 2007 Author Share Posted November 5, 2007 awesome, appreciated. had no idea where I should start. Link to comment https://forums.phpfreaks.com/topic/76006-data-qrray-with-limitless-entries/#findComment-384714 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.