Can someone please help me with this.
I have an Images table :-
create table images (
id integer unsigned not null auto_increment primary key,
image varchar(200) not null default ‘’
)ENGINE=InnoDB default CHARSET=latin1;
And a car table :-
create table cars (
id integer unsigned not null auto_increment primary key,
user_id integer unsigned not null,
title varchar(100) not null,
image_id integer unsigned not null,
constraint fk_cars_user foreign key (user_id) references
users(id),
constraint fk_cars_image foreign key (image_id) references images(id)
)ENGINE=InnoDB default CHARSET=latin1;
( The user table I’m using is the one provided by the Salted Login
Generator ).
Now I want my Cars Table to have many images.
- How should I modify FileColumn to upload…and view the images?
- How could I modify FileColum to allow for users to delete images?
Thanks in advance.