Links based on the ID

[Anon]

Say I have 2 tables in my database.

Table #1
id (auto incremented)
title

Table #2
id (auto incremented)
article

Now whenever I add or delete from these two tables it will be at the same time so the content will be related.

Say title in table 1 holding ID: 45 will be the title for the article (ID: 45) in table 2.

How would everyone recomend creating dynamic links that connect title to article?

Is it best to read the titles ID and then create a link based on that? How does everyone else do this?

[ace21]

First off if title can't have two articles then stick them in one table. There would be no need for two tables.

if not
to keep them in touch you would add a titleid to Table #2 that would contain the id for Table #1. That way when you have a title all you have to do is search for that id by titleid in Table #2.

Ace21