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" Link to comment https://forums.phpfreaks.com/topic/147885-solved-help-with-simple-join/ 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 Link to comment https://forums.phpfreaks.com/topic/147885-solved-help-with-simple-join/#findComment-776165 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"; Link to comment https://forums.phpfreaks.com/topic/147885-solved-help-with-simple-join/#findComment-776173 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.