Hey everyone. I'm tiring to create a site that lets users upload pictures.
I already create a user sign page and upload page that uploads to a dir, just tiring to find an example or a website with an example, how to create a script to put the user and upload id together.
In other words I'm create a rentals site where people can sign up and post there ads with pictures.
I was reading up about left join. Is it best to uses left join in this case?
MySql :
CREATE TABLE IF NOT EXISTS members (idint(11) NOT NULL auto_increment,usernamevarchar(64) NOT NULL,passwordvarchar(64) NOT NULL,emailvarchar(100) NOT NULL,firstnamevarchar(64) NOT NULL,lastnamevarchar(64) NOT NULL,companyvarchar(64) NOT NULL,urlvarchar(64) NOT NULL,addressvarchar(64) NOT NULL,cityvarchar(64) NOT NULL,regionvarchar(64) NOT NULL,countryvarchar(64) NOT NULL,zipvarchar(64) NOT NULL,datetimestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Table structure for table post_ads
CREATE TABLE IF NOT EXISTS post_ads (
id int(11) NOT NULL auto_increment,
user_im_id int(11) NOT NULL,
im_title varchar(64) NOT NULL,
im_description text NOT NULL,
im_name varchar(64) NOT NULL,
im_type varchar(64) NOT NULL,
im_size int(11) NOT NULL,
path varchar(60) NOT NULL,
im_date datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
I don't have an code yet, I'm just looking for an example or a web site with a tutorial.
Thanks in advance...
