Update counter, joined table with GET

[BEFOR]

There is a plan table Dir which needs to update the latest row per user on.

With the below mysql, however, Dir.Md is equal to a GET variable found as 'Mem' and needs to be joined to pull the latest row per user.

Dir.DirID is primary.
DCreateDate is obviously the date column.
DView the increment column.

How can it be done here (used to GET with php, not mysql)?

UPDATE update_last_row as T
inner
  join ( select DirID
              , max(DCreateDate) maxdate
           from update_last_row
         group by DirID ) as M
    on M.DirID = T.DirID
   and M.maxdate = T.DCreateDate
   SET T.DView = (T.DView + 1) WHERE // Dir.Md = ?

[tomhath]

You need to proofread what you type before posting it. Where did Dir.DirID and Dir.Md come from?

My guess at what you want is this. Just move the WHERE into the subselect, and since DirID is the primary key you don't need to have DCreateDate in the JOIN condition:

UPDATE update_last_row as T
inner
  join ( select DirID
         from update_last_row
         WHERE DirMd = $whatever
         order by DCreateDate desc
         limit 1 ) as M
    on M.DirID = T.DirID
   SET T.DView = (T.DView + 1)