Re: multiple choice dropdown box puzzle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Feb 23, 2009 at 10:25 AM, PJ <af.gourmet@xxxxxxxxxxxx> wrote:
> I think this is a tough one... and way above my head:
> PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO.
> Having a bit of a rough time figuring out how to formulate php-mysql to insert data into fields using a multiple dropdown box in a form.
>
> to post I am using the following:
> snip...
> $categoriesIN   = $_POST["categoriesIN"];
>
> ...snip...
>
> <select name="$categoriesIN[]" multiple="multiple">
>        <OPTION>Choose Categories...</option>
>                <OPTION VALUE="<? echo $categoriesIN; ?>">1
>                <OPTION VALUE="<? echo $categoriesIN; ?>">2
>                <OPTION VALUE="<? echo $categoriesIN; ?>">3
>                <OPTION VALUE="<? echo $categoriesIN; ?>">4
>                <OPTION VALUE="<? echo $categoriesIN; ?>">5
>        </SELECT>
>
> ...snip...
>
> $sql4 = "FOR ( $ii = 0 ; $ii < count($categoriesIN) ; $ii++ )
>        INSERT INTO temp (example) $categoriesIN[$ii]" ;
>        $result4 = mysql_query($sql4, $db);
> ...snip
>
> this does not work! The other posts work like a charm... but this...

You are confusing the PHP and MySQL.

<?php

$count = count($categoriesIN);
for ($ii = 0; $ii < $count; ++$ii) {
    $sql = "INSERT INTO temp (example) VALUES ('" .
mysql_real_escape_string($categoriesIN[$ii]) . "')";
    $result = mysql_query($sql, $db);
}

?>

MySQL also has an alternative syntax that you can use to do this in a
single statement:

<?php

$count = count($categoriesIN);
if ($count > 0) {
    $sql = "INSERT INTO temp (example) VALUES ";
    for ($ii = 0; $ii < $count; ++$ii) {
        if ($ii > 0) $sql .= ', ';
        $sql .=  "('" . mysql_real_escape_string($categoriesIN[$ii]) . "')";
    }
}

$result = mysql_query($sql, $db);

?>



Andrew

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux