Irate Posted February 24, 2014 Share Posted February 24, 2014 (edited) Hello everyone, it's been a while since I last made a topic, but here we go. So, to start, I am working with TYPO3 right now - to be exact, I am modifying an extension for someone - and I want to assign certain variables I can access with placeholders, but I have not worked with SQL in a while and since I have been here for a while, I figured I might as well ask you guys. I am grabbing entries from the table brandings which has three columns: one is called "brandingTargetPath", the second one is called "user" and the last one is "when", where the first two will be varchar(255) and the last one is int(11), with the table having an auto-increment Primary Key called "uid". Now, I can select the rows I want to and use "SORT BY when DESC" to get the most recent entries first, but then I want to differentiate between the different "brandingTargetPath" entries and show only the most recent entry in a certain path (the possible paths will be provided by PHP). Could anyone just hint me at the direction which SQL commands I should use? That'd be great, I can sort out the rest by myself. Thanks in advance, Irate Edited February 24, 2014 by Irate Quote Link to comment https://forums.phpfreaks.com/topic/286476-grab-entries-by-different-column-results/ Share on other sites More sharing options...
mac_gyver Posted February 24, 2014 Share Posted February 24, 2014 http://dev.mysql.com/doc/refman/5.5/en/example-maximum-column-group-row.html Quote Link to comment https://forums.phpfreaks.com/topic/286476-grab-entries-by-different-column-results/#findComment-1470396 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.