CMS

Report · Aug 16, 2008

Hi guys!
First of all I would like to apologize, if this has already brought up, but I haven´t found it.
I am creating a CMS with two tables that are created in phpmyadmin. The first table is the content table and I
have created the form so I can add, delete and update the content. Here is my problem: The second table is the menu table and I can´t figure out how to connect them together. I have added the menu in the form and added a list with the dynamic values are form the table, but when I add it adds a zero in the id_menu field
The tables look like this:

table 1 (menu)
id_menu
Title

table 2 (content)
id
id_menu
Author
Date
Text

Hopefully you understand my problem and I thank you in advance and appreciate any solutions I will get.

Best regards from Slovenia.

Report · Aug 17, 2008

The common field is id_menu but are they the same data type? They have
to be.

MooskirchnerQuintett wrote:

> Hi guys!
> First of all I would like to apologize, if this has already brought
> up, but I haven?t found it.
> I am creating a CMS with two tables that are created in phpmyadmin.
> The first table is the content table and I
> have created the form so I can add, delete and update the content.
> Here is my problem: The second table is the menu table and I can?t
> figure out how to connect them together. I have added the menu in the
> form and added a list with the dynamic values are form the table, but
> when I add it adds a zero in the id_menu field
> The tables look like this:
>
> table 1 (menu)
> id_menu
> Title
>
> table 2 (content)
> id
> id_menu
> Author
> Date
> Text
>
> Hopefully you understand my problem and I thank you in advance and
> appreciate any solutions I will get.
>
> Best regards from Slovenia.

--

Report · Aug 18, 2008

yes the are both INT

here are the all with their types

table 1 (menu)
id_menu = INT
Title = VARCHAR 30

table 2 (content)
id = INT
id_menu = INT
Author = VARCHAR 30
Date = DATE
Text = TEXT

Report · Aug 19, 2008

Show us the code

MooskirchnerQuintett wrote:

> yes the are both INT

--

Report · Aug 21, 2008

I have solved the problem. I connected the items with parameters, but I have an another question and that is what kind of mod should I write down in the parameters. I saw in the image gallery tutorial here on adobe.com he used mod = album . What should I use for latest news, because I am not making an album.

Report · Aug 21, 2008

I have not done the the image gallery tutorial so I have no clue what
or how mod is being used.