tables ? i think i have it MYSQL

[Maknib]

just trying to see if i have this right in my head here..

 

if i have a page that has a topic on it and many replies,  the tables would look like this..

 

would this be the right code to pull out the topic AND all responses for say.

www.mysite.com/view?id=1

 

$topic = 'SELECT * from topics where id = $id'

$replies = 'SELECT * from replies where replies.topic_id = $id'

[Ninjakreborn]

Essentially, yes.  It would be much more efficient if you set it up as a join instead.

Something like (untested)

"SELECT * FROM topics LEFT JOIN replies ON replies.topic_id = topics.ID"

[Maknib]

Essentially, yes.  It would be much more efficient if you set it up as a join instead.

Something like (untested)

"SELECT * FROM topics LEFT JOIN replies ON replies.topic_id = topics.ID"

 

thanks i'll look into it havn't looked into JOIN so LEFT JOIN and ON is foreign to me

[Ninjakreborn]

http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.

 

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

 

The second link will be the most beneficial in learning the basics of Joins.