SELECT where bla bla

Door scrippy do op 18-05-2011 00:09

2.002 views

Hallo,

heb hier een dual dropdown formulier en dat werkt prima. Maar nu wil ik het id nummer van de gekozen selectie met een SELECT uit de db halen en met een hidden form field met GET doorsturen naar een volgende pagina.

Maar na heel veel trail & error.... krijg ik de where niet juist in de query

Kan iemand helpen?


<?
// Database connection
$db_database = 'xxx';
$db_host = 'localhost';
$db_user = 'xxxxxx';
$db_pass = 'xxxx';
mysql_connect($db_host,$db_user,$db_pass) or die("Could not connect to MySQL (Main connection)");
mysql_select_db($db_database) or die("Could not connect to database (Main connection)");


function dual_linked_select(
$table,            // Table to create linked selects from
$table_column_01,        // Root category
$table_column_02,        // Subcategory of the root category
$group_02_default_option_text    // Default option text for the group 2 select
)
{

// Define globals
    global $javascript;
    global $group_01_options;
    // Define variables
    $javascript = null; // Hold
    $group_01_options = null;//Hold

// Assembly of Javascript starts
    $javascript .=<<<content
    /* Linked Dropdown Selects Script Start */
    function DefaultGroup2()
    {
        var x = document.getElementById("Group2");
        x.length = 0;
        VarGroup2 = document.getElementById("Group2");
        VarGroup2.options[VarGroup2.options.length] = new Option("$group_02_default_option_text","");
        document.getElementById("Group2").disabled = true;
    }

    function CheckGroup1Select()
    {
        // If no Group1 is selected clear the Group2 and set to default
        if(document.getElementById("Group1").value == "")
        {
        // Clear the Group2 select and set to default value
        DefaultGroup2();
        }

content;

// Javascript 
    $group_01_query = "SELECT ".$table_column_01." FROM ".$table." GROUP BY ".$table_column_01;
    $group_01_result = mysql_query($group_01_query) or die(mysql_error());
    while($group_01 = mysql_fetch_array($group_01_result))
    {
        $group_01_options .= '<option value="'.$group_01[$table_column_01].'">'.$group_01[$table_column_01].'</option>'."\r\n";

        $javascript .=<<<content
        else if(document.getElementById("Group1").value == "$group_01[$table_column_01]")
        {
            // Clear the Group2 and set to default value
            DefaultGroup2();
            // Set variable options for Group2 select
            VarGroup2 = document.getElementById("Group2");

content;

        $group_02_query = "SELECT * FROM ".$table." WHERE ".$table_column_01." = '".$group_01[$table_column_01]."' GROUP BY ".$table_column_02;
        $group_02_result = mysql_query($group_02_query) or die(mysql_error());
        while($group_02 = mysql_fetch_array($group_02_result))
        {
            $javascript .='            VarGroup2.options[VarGroup2.options.length] = new Option("'.$group_02[$table_column_02].'","'.$group_02[$table_column_02].'");'."\r\n";
        }

            $javascript .=<<<content
            document.getElementById("Group2").disabled = false;

        }

content;
    }
        $javascript .='    }'."\r\n";

} // End of dual_linked_selects function
?>

<?


// execute dual_linked_selects_function
dual_linked_select('type','group1','group2','Select...');

// Query member data from the database and ready it for display
$sql = mysql_query("SELECT type_id FROM type WHERE ???????? LIMIT 1");
while($row = mysql_fetch_array($sql)){
$type_id = $row["type_id"];
}

?>





<html>
<head>
    <title>Dual Linked Selects with PHP and MYSQL (without page reload)</title>
<script type="text/javascript" language="JavaScript">
<? echo $javascript; ?>
</script>
</head>

<body>


<br>


<form action="process4.php" method="get" enctype="multipart/form-data">
Maak een keuze:
<br>
<select id="Group1" name="group1" onChange="CheckGroup1Select(this);">
<option value="">Select...</option>
<? echo $group_01_options; ?>
</select>

<br><br>

Maak een keuze 
<br><br>

<select id="Group2" name="group2"><? echo $group_01_options; ?></select>
 <input type="hidden" name="type_id" value="<?php echo $type_id; ?>"> 
 <input type="submit" value="Submit"> 
</form>

<br> 

</body>

</html>

[size=xsmall]Toevoeging op 18/05/2011 19:21:31:[/size]

o Ja het gaat om de query die start op regel 91 t/m 97

Wat moet ik achter where zetten om het $type_id te krijgen