Displaying records from 2 tables (PHP)

1

i’ve two tables “homes” and “images”

eg: homes

CREATE TABLE `homes` (
  `mls` varchar(11) collate latin1_general_ci NOT NULL,
  `address` varchar(255) collate latin1_general_ci NOT NULL,
  `property_type` tinytext collate latin1_general_ci,
  `house_style` tinytext collate latin1_general_ci,
  `garage` varchar(255) collate latin1_general_ci default NULL,
  `age` int(11) default NULL,
  `bedrooms` tinyint(4) default NULL,
  `washrooms` varchar(255) collate latin1_general_ci default NULL,
  `features` text collate latin1_general_ci,
  `house_size` int(11) default NULL,
  `price` varchar(11) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`mls`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

and

CREATE TABLE `images` (
  `id` int(11) NOT NULL auto_increment,
  `mls` varchar(11) collate latin1_general_ci NOT NULL,
  `name` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;

there are more than one images for each mls. i just want to display all the house in “homes” table with one image for each home from “images” table. im trying this query

"SELECT h.mls, h.address, h.property_type, h.house_style, h.garage, h.age, h.bedrooms, h.washrooms, h.features, h.house_size, h.price, i.name FROM homes AS h, images AS i WHERE h.mls = i.mls"

with this im getting descripton for all the images in “images” table while I want just one image for each house.

u can also take a look here on code

it displays 2 homes with mls c32268781 while i want just one