Must be nice!
All right, I have it down to one last task; updating the post "subject" field. Can anyone help me formulate the SQL query to do this?
The field in table A is called "subject". (Table A contains the post's information)
It needs to be updated to the field called "title" from table B (Table B contains the thread info).
The two tables are linked as follows:
table A , field "ID_TOPIC"
and
table B, field "tid"
The trick is that in the update, the information has to be preceded with "Re: " .
Anyone?
|