Hello list, this is my first table for a simple php page and I'm hoping someone could briefly review its structure. The only fields I'll be sharing are property_name and type. Are they set up properly for select join queries?
thank you, justin Database=properties Tables are available_properties, property_names, and details create table available_properties ( av_pro_id int not null auto_increment property_name varchar (50) not null type varchar (25) city varchar (25) description varchar (125) number_of_units varchar (25) primary key (av_pro_id) ); create table property_names ( pro_id int not null auto_increment property_name varchar (50) not null address varchar (100) cross_street varchar (50) primary key (pro_id) ); create table details ( d_id int not null auto_increment type varchar (25) price smallint floor varchar (15) sq_ft smallint suite smallint description text available varchar (15) primary key (d_id) ); sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
