[demios]

Originally Posted by dwbro1

well not getting blank page anymore but still showing the other users in the list. Something else must be causing them to think there is info there. Here is link you can see.

http://thebluelodge.org/forums/userpage.php

Ok this needs you to modify three lines of code just adding the same bit:

On line 142 original code

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid) 


Modified code

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid) WHERE pagedata <> '' 


On line 147 original code

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid) 


Modified code

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid) WHERE pagedata <> '' 


On line 152 original code

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid) 


Modified code

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid) WHERE pagedata <> '' 


You will notice that all the changes are identical, this is not a mistake.

All you are really doing is adding a WHERE command to the end of each of these rows:

PHP Code:

 WHERE pagedata <> '' 


So the database now only returns records WHERE pagedata is NOT EQUAL TO empty.