Ok - I'm stuck... (MySQL)

[lukemedway]

Right I have asked this question before, but I don't think anyone understood what I meant entirely.

I am stuck with referencing with mysql, for example:

I have a news post, and I want to relate the comments to that news post so that they display to the corresponing post.

I understand that you can use Joins and that I must have a news_id in both the tables News_data and Comments_data.

The problem I can't get round is this... In the news table (news_data), there is an auto incrementing field called news_id, obviously, when a new record is entered this increments by 1.

This make sense to anyone, however, in the comments table there is a normal Integer field called news_id... but I don't know how to insert the News_id into that field which corresponds with the news_post in the news_data table.

[jonsof]

if i understood correctly, you have a table like this

a good way to do that is passing variables via url

Say that you have a page where you are posting news
then nearby each post you can add a link like "comment it"

<a href=comments.php?id=".news['id'].">Comment it</a>

comments.php

connection to database
from of comments
submit and then



INSERT INTO comments(comment_id,comment_data,news_id) VALUES (NULL,'Here you put he data','$_GET['id']');

Then in you comments table you have the news_id which is the news you have commented.

It's a good way to relate via php (FOREIGN KEYS in sql)

Tell me if something is wrong

[ahundiak]

/ Insert the news item
Just assume (as an example)
that the table has a column called name
/
mysql_query("Insert into news_data (name) values ('$news_name')");

/ Now get the id of the record just inserted /
$news_id = mysql_insert_id();

/ And start inserting some comments /
mysql_query("Insert into comments_data (news_id,comment) values ($news_id,'$comment')")

Hope this helps.

[lukemedway]

Wow, thanks guys that's just what I needed. 😃