[Cagez]

I'm writing a little article manager and I want to have it pull the avatar out of my vbulletindatabase based on a userid. I've got what I want, but what if the user doesn't have an avatar? This means that there won't be a row for that username in "customavatar" (where vb keeps the avatar info). Will mySQL through an error or will the u.filename just be blank? This is what I'm hoping for because I want to show a default image if they haven't set one.

TIA

PHP Code:

//(TABLE_PREFIX is a define of my table prefix I'm using for my system)



'SELECT a.articleid, a.categoryid, a.title, a.desc, u.filename FROM '.TABLE_PREFIX.

'_articles a, customavatar u WHERE u.userid = a.userid ORDER  BY a.articleid DESC LIMIT 0 , 10' 

[nd2]

'SELECT a.articleid, a.categoryid, a.title, a.desc, u.filename FROM '.TABLE_PREFIX.
'_articles a, customavatar u WHERE u.userid = a.userid ORDER BY a.articleid DESC LIMIT 0 , 10'

in that query if it does not find a match for u.userid = a.userid it will not return the result.

however if you do a LEFT JOIN

'SELECT a.articleid, a.categoryid, a.title, a.desc, u.filename FROM '.TABLE_PREFIX.
'_articles a LEFT JOIN customavatar u ON u.userid = a.userid WHERE u.userid = a.userid ORDER BY a.articleid DESC LIMIT 0 , 10'

if there is no avatar, it will return a empty rows if it does not exsist.

[Cagez]

Sweet, I'll test it out Thanks

[nd2]

np