Show multiple images but not selectoptions

[Joepiooo1988]

Hello,

 

I need help with some code because I cant figure it out on my own:(

 

This is my Class:

 

<?php

include_once "connect.class.php";

class merken extends connect
{    
    
    private $merkenlijst;
    
    public function getMerken($database, $id = NULL)
    {
        $sql = "SELECT * FROM ".$database."_merken";
        if(!empty($id))
        {
            $sql .= " WHERE merk_code=:id LIMIT 1";
        }
        else
        {
            $sql .= " ORDER BY merk_naam ASC";
        }
        try
        {
            $stmt = $this->db->prepare($sql);
            if(!empty($id)){ $stmt->bindParam(":id", $id, PDO::PARAM_STR); }
            $stmt->execute();
            $this->merkenlijst = $stmt->fetchAll(PDO::FETCH_OBJ);
            $stmt->closeCursor();
            
            return $this->merkenlijst;
        }
        catch (Exception $e)
        {
            die ( $e->getMessage() );
        }
    }
    
    public function __construct($dbo = NULL)
    {
        parent::__construct($dbo);
    }
}

?>

 

 

And this is my code for the output:

 

<?php
    include_once "class/merken.class.php";
    $merkclass = new merken($dbo);
?>
                    <br />
                    <div class="bandwielkolom">
                        <form action="index.php?lang=nl&p=<?php echo $_GET['p']; ?>#keuze" method="post">
                            <table class="bandentabel">
                                <tr>
                                    <th colspan="2">Zoek op merk<a name="wiel"></a></th>
                                </tr>
                                <tr>
                                    <td>Merk:</td>
                                    <td>
                                        <select name="wiel_merk">
                                            <option value="0">- Merk -</option>
<?php
    $merken = $merkclass->getMerken($website);
    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'] == $merk->merk_code || isset($_POST['wiel_submit']) && $_POST['wiel_merk'] == $merk->merk_code) { echo " selected=\"selected\""; }
        echo ">".$merk->merk_naam."</option>\n";
    }
?>
                                        </select>
                                    </td>
                                </tr>
                                <tr>
                                    <td> </td>
                                    <td><input type="submit" name="wiel_submit" value="Zoek" /></td>
                                </tr>
                                <tr>
                                    <td colspan="2"> </td>
                                </tr>
                                <tr>
                                    <td colspan="2"> </td>
                                </tr>
                            </table>
                        </form>
                    </div>
                    <div class="clearboth"></div>
                    <br />
<?php
if(isset($_POST['wiel_submit']) && $_POST['wiel_submit'] == "Zoek" || isset($_GET['merk']))
{
    $merk = NULL;
    if(isset($_POST['wiel_submit']) && $_POST['wiel_submit'] == "Zoek")
    {
        $merk = $_POST['wiel_merk'];
    }
    $merken = $merkclass->getMerken($website, $merk);
?>
                    <img src="http://www.etyre.net/preview/bnet/logos/<?php echo str_replace(".png", "_150.png", $merken[0]->merk_logo); ?>" width="150" class="logo" alt="<?php echo $merken[0]->merk_naam; ?>"/>
                    <div id="merken">
                    <li><span class="title">Foto <?php echo $merken[0]->wiel_foto; ?></span>
                            <a href="http://www.inter-tyre.nl/inter-tyre/images/w3/<?php echo $merken[0]->wiel_foto; ?>" class="preview" title="Fotonummer: <?php echo $merken[0]->wiel_foto;  ?>">
                                <img src="http://www.inter-tyre.nl/inter-tyre/images/w2/<?php echo $merken[0]->wiel_foto; ?>" alt="Fotonummer: <?php echo $merken[0]->wiel_foto; ?>" class="wheelImg"/>
                            </a>
                        <div class="clearboth"></div>
                    </div>
<?php
}
?> 

 

What I try to accomplish is the following:

 

I got a option selectfield and you can select different brands. After you submit you get the name and logo of the brand and the wheel that has that brand.

 

Now I only have 11 different brands with a wheel but I got more wheels with the same brand and I want to show all the wheels that belong to the brand you selected.

 

Here is how my database looks like:

 

http://imageshack.us/photo/my-images/685/databaseh.png

 

So lets say I put in another Rosso with a different picture. When I select Rosso and click submit I get 2 wheels of Rosso. The only thing that is happening now is that in my selectbox I can choose Rosse 2 times! And when I add another Rosso wheel I can choose 3 times. Same is with merk_logo that is there 3 times...

 

Can somebody help me with the code I got this far and help me getting this thing to work like a charm?

 

I know I am very close but just need to fix this...

 

Thanks

 

[Joepiooo1988]

Is there nobody that can help me with this problem? I tried DISTINCT but that did not work very well

[ManiacDan]

Only select the columns you need.  If you're only displaying merk_name, then only select merk_name from the table.  Then your DISTINCT will work.

 

Also, this is not the right way to set up your database, look into normalization and third normal form.  Your "merk"s should be their own table, with each row linking back to them.  That way, you could have done a select * from merk to get your dropdown.

[Joepiooo1988]

Hi,

 

Thanks for your reply. Can you give me an example how you would use DISTINCT with my code because everything I tried did not work...

[ManiacDan]

Did you not read what I said?  I'm not going to delete the * and type out merk_name for you.