https://www.webmaster-forums.net/crss/node/1005917 en https://www.webmaster-forums.net/web-database-development/mysql-help#comment-1031564 <p>How about selkect MAX(date) from table where subject = $row[1]?</p> <p>Am I misunderstanding the question? Remember, SQL doesn't understand the concept of "last row" -- so unless you have some kind of counter on the table, or a sequentially ascending date, this isn't something you can do. You really need to define "last" other than by the last row inserted (if there is no timestamp on each row).</p> <p>Ralph</p> <p>------------------<br /> <a href="http://www.hockeydb.com" class="bb-url">http://www.hockeydb.com</a></p> Mon, 08 May 2000 14:18:00 +0000 Ralph Slate comment 1031564 at https://www.webmaster-forums.net