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
Problem Query
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA