Whats wrong with that query??

[Kars10]

Hi Guys!!
Whats wrong with that query??

$post=$DB_site->query_first("
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
FROM post
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
LEFT JOIN user ON user.userid=post.userid,ratetotal,ratenum,allowrat e
LEFT JOIN userfield ON userfield.userid=user.userid
".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '$postid'
");

Get a Mysql-error:

Invalid SQL:

SELECT

post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,

attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,avatar.avatar path,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline

FROM post

LEFT JOIN icon ON icon.iconid=post.iconid

LEFT JOIN user ON user.userid=post.userid,ratetotal,ratenum,allowrat e

LEFT JOIN userfield ON userfield.userid=user.userid

LEFT JOIN avatar ON avatar.avatarid=user.avatarid

LEFT JOIN customavatar ON customavatar.userid=user.userid

LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid

WHERE post.postid = '24923'



mysql error: Table 'db66781886.ratetotal' doesn't exist



mysql error number: 1146

But the table "ratetotal" exists in user...

Anyone a idea?? :(

[NTLDR]

If you mean you have a ratetotal column in the user table then add user.ratetotal,user.ratenum,user.allowrate somewhere before FROM post, you can't select those coloumns after you have used the FROM clause :)

[Kars10]

Thank you NTLDR for the fast reply!!
But im stupid in debugging a error :(
can you please-please-please post the correct query here,... :)
That would be great.

[NTLDR]

This should be correct if I've understood what you said :)

$post=$DB_site->query_first("
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,user.ratetotal,user.ratenum,user.allowra te,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
FROM post
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '$postid'
");

[Kars10]

Thank you so much!!
Works great NTLDR!
Sorry for my bad english... :( ;)