laat maar 1 resultaat zien (Opgelost)

<?php 
endif;

if ($go =="go"):

$sql = "SELECT * FROM brommobielen WHERE merk='".$_POST['merk']."';
$query = mysql_query($sql);
  if ($arr['res'] = mysql_fetch_object($query)) {  
    echo "dealer:" . $arr['res']->dealer . "<br />";  
    echo "merk:" . $arr['res']->merk . "<br />";  
    echo "type:" . $arr['res']->type . "<br />";  
    echo "prijs:" . $arr['res']->prijs . "<br />";
 	echo "<br />";
} else {
           print (mysql_error());
  }  
	  
     
endif; 
?>

<?php 
endif;
 
if ($go =="go"):
 
$sql = "SELECT * FROM brommobielen WHERE merk='".$_POST['merk']."';
$query = mysql_query($sql);
  if ($arr['res'] = mysql_fetch_object($query)) {  
    echo "dealer:" . $arr['res']->dealer . "<br />";  
    echo "merk:" . $arr['res']->merk . "<br />";  
    echo "type:" . $arr['res']->type . "<br />";  
    echo "prijs:" . $arr['res']->prijs . "<br />";
 	echo "<br />";
} else {
           print (mysql_error());
  }  
 
 
endif; 
?>

CREATE TABLE `brommobielen` (
  `id` int(11) NOT NULL auto_increment,
  `dealer` varchar(150) NOT NULL default '',
  `provincie` varchar(150) NOT NULL default '',
  `merk` varchar(150) NOT NULL default '',
  `type` varchar(50) NOT NULL default '',
  `prijs` int(10) NOT NULL default '0',
  `omschrijving` text NOT NULL,
  `afbeelding` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

CREATE TABLE `brommobielen` (
  `id` int(11) NOT NULL auto_increment,
  `dealer` varchar(150) NOT NULL default '',
  `provincie` varchar(150) NOT NULL default '',
  `merk` varchar(150) NOT NULL default '',
  `type` varchar(50) NOT NULL default '',
  `prijs` int(10) NOT NULL default '0',
  `omschrijving` text NOT NULL,
  `afbeelding` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;