[rex_b]

I have a problem..

Everything seems to work fine except when I try to view my member's public profile. So put back my original member.php and still have errors. help!!

Invalid SQL: 
		SELECT 
		userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
		IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, level, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, " AS profilepic, customprofilepic.dateline AS profilepicdateline
		FROM vb3user AS user
		INNER JOIN vb3userfield AS userfield ON (user.userid = userfield.userid)
		INNER JOIN vb3usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
		LEFT JOIN vb3useraward AS useraward ON (useraward.userid = user.userid) LEFT JOIN  vb3reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) LEFT JOIN vb3avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb3customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb3customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) 
		WHERE user.userid = 58

	
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '" AS profilepic, customprofilepic.dateline AS profilepicdatelin

mysql error number: 1064

Date: Wednesday 08th of September 2004 03:56:16 PM
Script: http://www.***/forum/member.php?userid=58
Referer: http://www.***/forum/showthread.php?p=26959#post26959