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????

Ok how can I update the post table to

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

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

I got an error message. :(

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]

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.