SELECT latest value from DB?

[billy_111]

Hey Shrapnel,

I dont think i have explained properly.

And yes i will be using mysql escape string when i have finished testing..

I changed the SQL to this:-

        $past_insert = "UPDATE tbl_job_reviews SET company = '".$_POST['txt_working']."' WHERE member_id = '".$_SESSION['MEM_ID']."' AND date_added = (select max(date_added) from tbl_job_reviews WHERE member_id = '".$_SESSION['MEM_ID']."')"; 

So i want to update the tbl_job_reviews table. But i want to update ONLY the latest record with the mem_id of lets say 18. There are multiple tuples in the database where mem_id 18 exists so i only need to ever update the last one..

Therefore i thought i would need to use the date_added field in my database. Can i do this?

Billy