whats wrong with this?

PHP Code:

function getpictureurl($userid) {
  global $DB_site,$session;

  if ($pictureinfo=$DB_site->query_first("SELECT user.pictureid NOT ISNULL(picturedata) AS hascustom
                                         FROM user
                                         LEFT JOIN userpicture ON userpicture.userid=user.userid
                                         WHERE user.userid='$userid'")) {
  if ($pictureinfo['hascustom']) {
      return "userpicture.php?userid=$userid&dateline=$pictureinfo[dateline]";
    } else {
      return '';
    }
  }
} 


[Slynderdale]

PHP Code:

Database error in vBulletin 2.2.3:

Invalid SQL: SELECT user.pictureid NOT ISNULL(picturedata) AS hascustom
                                         FROM user
                                         LEFT JOIN userpicture ON userpicture.userid=user.userid
                                         WHERE user.userid='1'
mysql error: You have an error in your SQL syntax near 'ISNULL(picturedata) AS hascustom
                                         FROM ' at line 1

mysql error number: 1064 


[Neo]

Try using NULL instead of ISNULL

[Admin]

A comma is missing before NOT ISNULL.