Yes, if you mean that sometime in the past the subject said that he would be accompanying the person your talking to to an event that has not yet happened.
It might make it a little clearer if you add the word 'that' after 'he said' but it's not essential.
Yes, your sentence is correct. Its a future and past tense used.
Discover the hidden source of targeted traffic that unearths eager buying customers, drives them straight to your site, and literally explodes your profits almost overnight at just simple click unique article wizard.