TalkPHP - View Single Post

wGEric · 05-14-2008, 07:51 PM

sql Code:

SELECT forums.fid,forums.name,forums.DESC,posts.pid,posts.forumid
FROM forums,posts
WHERE posts.forumid = forums.fid

When you put single quotes around it it was looking for where the column's value is that string and not where the two columns equal.

Also you should avoid using keywords for column names (change desc to something else).

05-14-2008, 07:51 PM	#8 (permalink)
wGEric The Acquainted Join Date: Nov 2007 Posts: 125 Thanks: 0	sql Code: SELECT forums.fid,forums.name,forums.DESC,posts.pid,posts.forumid FROM forums,posts WHERE posts.forumid = forums.fid When you put single quotes around it it was looking for where the column's value is that string and not where the two columns equal. Also you should avoid using keywords for column names (change desc to something else). __________________ Eric Blog • phpBB