giraffemedia Posted February 16, 2011 Share Posted February 16, 2011 Hello, I have a table in my database that contains a list of issuse_numbers, each with a corresponding booking form number next to it like below… id(primary) issue_number booking_form_number 12306 92 3089 12305 93 3088 12304 92 3088 12303 94 3087 12302 93 3087 12301 92 3087 12300 112 3085 12299 111 3085 12298 110 3085 12297 109 3085 12296 108 3085 12295 107 3085 12294 106 3085 12293 105 3085 12292 104 3085 12291 103 3085 12405 103 3080 12404 102 3080 12403 101 3080 12402 100 3080 12401 99 3080 12285 98 3079 12284 97 3079 12283 96 3079 12282 95 3079 12281 94 3079 12280 93 3079 12279 92 3079 12278 91 3079 12365 92 3078 12364 91 3078 12363 90 3078 I would like to be able to find out the best way of getting the last issue number for any booking form. Is this a mysql query related thing in addition to using the php end function? I'm not sure how to group the rows together so I get something like… 91, 92, 93, 94, 95, 96, 97, 98 for booking number 3079 90, 91, 92 for booking number 3078 etc etc I would appreciate any help as it's driving me nuts! James Link to comment https://forums.phpfreaks.com/topic/227874-finding-the-last-record-in-array-from-mysql/ Share on other sites More sharing options...
BlueSkyIS Posted February 16, 2011 Share Posted February 16, 2011 if you are looking for the maximum issue_number for a given booking_form_number SELECT MAX(issue_number) FROM table_name WHERE booking_form_number = 3079 Link to comment https://forums.phpfreaks.com/topic/227874-finding-the-last-record-in-array-from-mysql/#findComment-1175021 Share on other sites More sharing options...
Psycho Posted February 16, 2011 Share Posted February 16, 2011 if you are looking for the maximum issue_number for a given booking_form_number SELECT MAX(issue_number) FROM table_name WHERE booking_form_number = 3079 To add to that, if you want the max booking number for all forms then this should do the trick SELECT booking_form_number, MAX(issue_number) FROM table_name GROUP BY booking_form_number Link to comment https://forums.phpfreaks.com/topic/227874-finding-the-last-record-in-array-from-mysql/#findComment-1175033 Share on other sites More sharing options...
ansharma Posted February 16, 2011 Share Posted February 16, 2011 Try this SELECT issue_number FROM `table name` ORDER BY `table name`.`issue_number` DESC Link to comment https://forums.phpfreaks.com/topic/227874-finding-the-last-record-in-array-from-mysql/#findComment-1175036 Share on other sites More sharing options...
giraffemedia Posted February 16, 2011 Author Share Posted February 16, 2011 if you are looking for the maximum issue_number for a given booking_form_number SELECT MAX(issue_number) FROM table_name WHERE booking_form_number = 3079 To add to that, if you want the max booking number for all forms then this should do the trick SELECT booking_form_number, MAX(issue_number) FROM table_name GROUP BY booking_form_number That worked great thanks. I had to tweak it a bit to get it to work how I needed but the MAX() bit was the key. I ended up with the following… $issue_numbers = mysql_query("SELECT ib_booking_form_number,ib_issue_number, MAX(ib_issue_number) AS end_issue FROM issues_booked GROUP BY ib_booking_form_number") or die(mysql_error()); while($row = mysql_fetch_array($issue_numbers)){ if ($row['end_issue'] == $_GET['issue_number']) { $booking_number[] = $row['ib_booking_form_number']; } } Thanks very much everyone. James Link to comment https://forums.phpfreaks.com/topic/227874-finding-the-last-record-in-array-from-mysql/#findComment-1175105 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.