I have two tables
userpie_history which is set out
userpie_incoming which is set out
what i want to do is grab the number that has come in and find the last person that sent a message to them and then take the user and insert it in to the user_id field on userpie_incoming.
by default when a new incoming message comes in it sets the user_id as null.
hopefully i have explained enough for some one to understand all date's are set via CURRENT_TIMESTAMP