Retroactive Signature?

Is there a hack that if a user has never had a signature, and has post a few times, then adds a signature and forces that signature into all of their old posts?

[007]

Interesting. Is there a way to make it so if someone has a signature it is automatically shown in all of their posts and do away with the "Show sig in this post" feature altogether????

[007]

Ok how can I update the post table to

PHP Code:

UPDATE post SET showsignature = 1 WHERE (see below) 


...WHERE the user who posted the post actually has a signature?

[filburt1]

[sql]
UPDATE p.post SET p.showsignature = 1 WHERE u.signature != "" AND p.userid = u.userid;
[/sql]

[007]

I got an error message.

[filburt1]

Whenever you get an error message, you need to post it...
[sql]
UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid;[/sql]

[007]

Sorry

K, got this this time:

Error

SQL-query :

UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid

MySQL said:

Unknown table 'user' in where clause

I have the user table too... obviously. Weird.