Forums

This topic is locked

Content Management

Posted 17 May 2002 12:03:54
1
has voted
17 May 2002 12:03:54 Jonathan Manning posted:
lo peeps,

I hope the following makes sense to you, please forgive if it doesn't as I am a newbie when it comes to Ultradev, Phakt and Mysql, I hope this is the correct forum.

I want to make a very simple content management system using the tools above.

I have tried creating a table in MySQL called tblContent and then I made a form in Ultradev, which takes these details:

1) ContentId
2) ContentName
3) ContentTitle
4) ContentText
5) ContentAuthor

After submiiting to the database the ContentName is displayed on a navigation bar on the left hand side of the screen as a link to a page called content.php, I then pass the ContentName as a url variable to content.php and it displays the content/story etc, but as I need to have 2 recordsets, one to show the Link and another to show the story on a separate page, I get a page without anything on it including errors.

I think I might need to use 2 tables in MySql, and relate then? but I am unsure, what would be the best way to achieve this?

A tutorial on Joining/relating tables would be good, sorry if this question has been asked on these forums elsewhere, I am unsure as to what this type of thing is called. <img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>

cheers


Reply to this topic