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? Quote Link to comment 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... Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.