select (select count(id) from setapak_r_tb)+(select count(id) from damansara_pj_r_tb)+(select count(id) from sentul_mont_r_tb)+(select count(id) from cheras_amapang_r_tb)+(select count(id) from kl_r_tb)+(select count(id) from sri_klang_r_tb) as total<br/><br/>
	          create table sri_klang_r_tb(
				  
				  id int primary key auto_increment,			 
				  username varchar(22),
				  ad_id varchar(32) not null,
				  ad_address varchar(62),
				  ad_furnish varchar(18),
				  ad_full varchar(388) not null,
				  ad_rental float(9,2) not null,
				  ad_contact varchar(14) not null,
				  ad_name varchar(36),
				  de_state varchar(28),
				  de_location varchar(28),
				  de_area varchar(28),
				  pic_main varchar(88),
				  pic_1 varchar(88),
				  pic_2 varchar(88),
				  pic_3 varchar(88),
				  pic_4 varchar(88),
				  pic_5 varchar(88),
				  pic_6 varchar(88),			  
				  create_time int not null,
				  create_time_read varchar(28) not null,
				  ad_title varchar(48),
				  pic_1_tn varchar(88),
				  pic_2_tn varchar(88),
				  pic_3_tn varchar(88),
				  pic_4_tn varchar(88),
				  pic_5_tn varchar(88),
				  pic_6_tn varchar(88),
				  table_loc varchar(18)				  
			  )	       
		   <br/>Connection Fail.