How can I test (in php) if a user has a profile pic or not?

[richy96]

The title says it all

How do I check whether a user has a profile pic?

Thanks
++++y

[Speysider]

Going to their profile is too hard?

[richy96]

It wasn't a flippant question lol

I am writing a modification for my site which checks how much of a users profile is completed, then gives it a 'star rating'. Member search results can then be sorted with the most completed profiles first.

[Lynne]

I believe you would take a look in the customprofilepic table and see if there is a row for that particular userid.

[richy96]

Thanks Lynne that did the trick

I was a bit surprised when the SQL returned 'resource id# blah blah ' instead of the data I expected but a quick google found the reason for that

Thank you!

rich


--------------- Added [DATE]1280957839[/DATE] at [TIME]1280957839[/TIME] ---------------

BTW why does the SQL return all that resource ID# stuff? I can't see it anywhere in the table

rich