Hello
I'm quite a newbie with PHP and MySQL - I'm using Dreamweaver
I would like to make a "sophisticated" insert form but I don't manage:
My insert form should have several drop down menus displaying cities, regions and countries + a large description text aera etc...
The problem is that my main content table is made of foreign keys and I only get a numeric input instead of these beautiful dropdown menus or large text aera 🙁
Is it possible to create a insert record with related tables ? How???
Here is a part of my database:
content Table
ID = primary key
Description ID = foreign key
City ID = forign key
Type ID = foreign key
Contact ID = foreign key
(...)
Description Table
Description ID = primary key
Title = tiny text
Description = long text
Image = path to a image file
(...)
City
City ID = primary key
city name = tiny text
region ID = foreign key
Region
region ID = primary key
region name = tiny text
country ID = foreign key
country
country ID = primary key
country name = tiny text
etc...
I would like my form to have:
Country (drop down)
region (drop down)
city (drop down)
title (small text)
description (large text)
image (file upload)
