Hello,

I have a script that is reading my wheel brands. If I select a brand it show all the wheels from that brand...

That is because I used GROUP BY merk_naam... But when I dont select a brand at all and press submit it should show all the wheels from every brand.

Now he is only showing one wheel for a brand.

Can somebody help me with the following:

I have two tables now:

Table 1: it_merken

Table 1

Table 2: it_merken2

Table 2

I want the merk_naam in a dropdown list

But when I dont use GROUP BY I get a lot of double brandnames.

How can I JOIN the merk_naam from my too tables so that in my dropdown list it only shows one brand and not the doubles? And when I dont select anything and press submit it shows all my wheels?

Can somebody help me out?

This is the class I got now with the GROUP BY:

PHP Code:
<?php

class merken extends connect
{   
    
/**
     * Merken lijst
     * 
     * @param object
     */
    
private $merkenlijst;

    
/**
     * Vraag merken op uit database
     *
     * @param int $id
     * @return array
     */
    
public function getMerken($database$id NULL)
    {
        
$sql "SELECT merk_code, merk_logo, merk_naam, wiel_foto, wiel_nummer, wiel_info FROM ".$database."_merken";
        if(!empty(
$id))
        {
            
$sql .= " WHERE merk_code=:id"
        }
        else
        {
            
$sql .= " GROUP BY merk_naam";
        }
        try
        {
            
$stmt $this->db->prepare($sql);
            if(!empty(
$id)){ $stmt->bindParam(":id"$idPDO::PARAM_STR); }
            
$stmt->execute();
            
$this->merkenlijst $stmt->fetchAll(PDO::FETCH_OBJ);
            
$stmt->closeCursor();

            return 
$this->merkenlijst;
        }
        catch (
Exception $e)
        {
            die ( 
$e->getMessage() );
        }
    }

    
/**
     * Maak een database object en sla de data op
     *
     * @param object $dbo
     * @return void
     */
    
public function __construct($dbo NULL)
    {
        
/*
         * Roep de parent constructor aan om te controleren op
         * een database object
         */
        
parent::__construct($dbo);
    }
}

?>
That is given me each brand one time in my dropdown but when I select nothing, I want to show all brands and because I use GROUP BY now I only see one wheel per brand after submit.

This is my PHP and HTML:

PHP Code:
<div class="bandwielkolom">
                        <form name="wielenzoeken" action="index.php?lang=<?php echo $lang?>&amp;p=<?php echo $_GET['p']; ?>#keuze" method="post">
                            <table class="wielentabel">
                                <tr>
                                    <th colspan="2"><?php echo $searchwheelsbybrand?><a name="wiel"></a></th>
                                </tr>
                                <tr>
                                    <td><?php echo $brand?>:</td>
                                    <td>
                                        <select name="wiel_merk" onchange="enable()">
                                            <option value="0">- <?php echo $brand?> -</option>
<?php
    $merken 
$merkclass->getMerken($website$merk);
    foreach(
$merken as $merk)
    {
        echo 
"\t\t\t\t\t\t\t\t\t\t\t<option value=\"".$merk->merk_code."\"";
        if(isset(
$_GET['search']) && $_GET['search'] == "wiel" && isset($_GET['merk']) && $_GET['merk'] != "0" || isset($_POST['wiel_submit']) && $_POST['wiel_merk'] != "0") { echo " selected=\"selected\""; }
        echo 
">".$merk->merk_naam."</option>\n";
    }
?>
                                        </select>
                                    </td>
                                </tr>
                                <tr>
                                    <td>&nbsp;</td>
                                    <td><input type="submit" name="wiel_submit" value="<?php echo $search?>"/></td>
                                </tr>
                                <tr>
                                    <td colspan="2">&nbsp;</td>
                                </tr>
                                <tr>
                                    <td colspan="2">&nbsp;</td>
                                </tr>
                            </table>
                        </form>
                        </div>
                    </div>
                    <div class="clearboth"></div>
                    <div id="main-right">             

<?php
foreach($teksten as $tekst)
{
    
?>
                    <h1><strong><?php echo $tekst->tekst_header?></strong></h1>
                    <?php echo $tekst->tekst_content."\n"?>
                    <?php
                        
if(!empty($tekst->tekst_img))
    {
?>
                                                <div class="imgcontainer">
                        <div class="imgcontent">
                            <img src="<?php echo $tekst->tekst_img?>" class="content_image" alt="<?php echo $tekst->tekst_header?>" />
                        </div>
                    </div>
<?php
    
}
?>

<?php
}

?>
</div>
</div>
                    <div class="clearboth"></div>
                    <div id="main-left">
                    <ul class="wheels">
<?php
if(isset($_POST['wiel_submit']) && $_POST['wiel_submit'] == $search || isset($_GET['merk']))
{
    
$merk NULL;
    if(isset(
$_POST['wiel_submit']) && $_POST['wiel_submit'] == $search)
    {
            echo 
"\t\t\t\t\t<h2>".$brandselection."</h2>
\t\t\t\t\t<br />\n"
;
        
$merk $_POST['wiel_merk'];
    }
?>
<?php

    $merken 
$merkclass->getMerken($website$merk);
        foreach(
$merken as $merk)
    {
?>
                                            <li><span class="title"><?php echo $merk->wiel_info?></span>
                            <a href="http://www.website.nl/website/images/w3/<?php echo $merk->wiel_foto?>" class="preview" title="Fotonummer: <?php echo $merk->wiel_foto;  ?>">
                                <img src="http://www.website.nl/website/images/w3/<?php echo $merk->wiel_foto?>" alt="Fotonummer: <?php echo $merk->wiel_foto?>" class="wheelImg"/>
                            </a>
                            <span class="descr">
                            <img src="http://www.website.net/preview/bnet/logos/<?php echo str_replace(".png""_100.png"$merk->merk_logo); ?>" style="padding-left:45px;" width="100" class="logo-merk" alt="<?php echo $merk->merk_naam?>"/>
                            </span>
                                </li>                         
<?php
    
}
?>
</ul>
<?php
}
?>
        </div>
Any help is welcome because I cant figure it out...

Thanks in advance