scarhand Posted March 4, 2009 Share Posted March 4, 2009 im terrible at joins... there are 2 tables, one is called "smf_topics" and one "smf_messages" they both contain "ID_TOPIC" fields, so i am trying to create a SELECT that will select all smf_messages that are topics heres my query that does not work: "SELECT * FROM smf_messages WHERE smf_messages.ID_TOPIC = smf_topics.ID_TOPIC" Quote Link to comment Share on other sites More sharing options...
scarhand Posted March 4, 2009 Author Share Posted March 4, 2009 this doesnt work either: "select * from smf_messages join smf_topics on smf_messages.ID_TOPIC = smf_topics.ID_TOPIC" ugh i suck Quote Link to comment Share on other sites More sharing options...
scarhand Posted March 4, 2009 Author Share Posted March 4, 2009 nevermind i got it $query ="SELECT m.ID_TOPIC, m.posterTime, m.ID_MEMBER, m.subject, m.posterName, m.body, t.numReplies FROM smf_messages as m, smf_topics as t WHERE m.ID_MSG = t.ID_FIRST_MSG AND m.ID_BOARD = 2 ORDER BY m.ID_MSG DESC"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.