Problem Query
Posted: Thu Jun 22, 2006 6:20 pm
I dunno why this doesn't work, it looks fine to me. Here the echo'd query...
(Bolded for easy reading)
select CommentsIndex.CommentID, CommentsIndex.MemberID, `TimeStamp`, `CommentBody`, `PostCount`, `MemberUsername`, `ImageOne`, `One`, `Two`, `Type`
from `CommentsIndex`
join `Comments`
on (CommentsIndex.CommentID = Comments.CommentID)
join `PostCount`
on (CommentsIndex.MemberID = PostCount.MemberID)
join `Index`
on (CommentsIndex.MemberID = Index.MemberID)
join `Pictures`
on (CommentsIndex.MemberID = Pictures.MemberID)
join `Profile` on (CommentsIndex.MemberID = Profile.MemberID)
where CommentsIndex.CommentID='1199'
Error returned is syntax error near 'Index . MemberID
(Bolded for easy reading)
select CommentsIndex.CommentID, CommentsIndex.MemberID, `TimeStamp`, `CommentBody`, `PostCount`, `MemberUsername`, `ImageOne`, `One`, `Two`, `Type`
from `CommentsIndex`
join `Comments`
on (CommentsIndex.CommentID = Comments.CommentID)
join `PostCount`
on (CommentsIndex.MemberID = PostCount.MemberID)
join `Index`
on (CommentsIndex.MemberID = Index.MemberID)
join `Pictures`
on (CommentsIndex.MemberID = Pictures.MemberID)
join `Profile` on (CommentsIndex.MemberID = Profile.MemberID)
where CommentsIndex.CommentID='1199'
Error returned is syntax error near 'Index . MemberID