PHP/mysql - Select Multiple and Arrays

Anon

I want to take user selections on a HTML page and store it in the database like so: "blue||red" (that is if the user selects blue and red). So, here is my failed attempt:

The HTML Form:
<select name="crud[]" multiple>
<option value="blue">Blue<br>
<option value="red">Red<br>
<option value="green">Green<br>
<option value="orange">Orange </select>

Now posted and doing this:
while (list($crud_a, $crud_b) = each ($crud))
{
$crud_complete = $crud_a||$crud_b";
}

$sql = "UPDATE stuff SET crud = $crud_complete";
....

Obviously I am doing something wrong. It records in the db as: "2||Green"

Any suggestions? Thanks, very much, in advance.

Anon

hello,
I am looking for a php code that can perform the following:
based on this mysql db

2002-08-01 val1 test1 TEST val2 5
2002-08-02 val1 test1 TEST val2 5
2002-08-03 val1 test2 TEST val2 5
2002-08-03 val1 test8 TEST val2 3
2002-08-03 val1 test2 TEST val2 0
2002-08-03 val1 test3 TEST val2 9
2002-08-04 val1 test8 TEST val2 6
2002-08-04 val1 test3 TEST val2 5
2002-08-04 val1 test3 TEST val2 5
2002-08-03 val1 test8 TEST val2 6
2002-08-05 val1 test3 TEST val2 0

I need to be able to only show all results from column 3 that has value > 1 from last column and must not have any other vaule in column 5 that is < 2 in same day also occured 3 days in a row based on last date from column 1

so the result if query above table will be this:
2002-08-04 val1 test8 TEST val2 6

I really appreciate any help ..
Thanks in a dvance....

Anon

Sorry, Posted wrong .....

smook

hey confused...

I think you are mistaken on how the crud array looks....

the array isn't (red,green,blue) etc ... its more like:

(0,red),(1,green)(2,blue) etc....

so when your list($crud_a,$crud_b) goes around... $crud_a is your key and $crud_b is your value.

The loop however is fine, the problem really is that your $crud_complete = ($crud_a,$crud_b) keeps overwriting itself every time you loop around. Thus you only get one value and its key - like: 2||green

Instead, try this inside of your loop:

$crud_complete .= ($crud_b||);

The .= appends the value and a "||" to the end of the existing $crud_complete.

You might want to change the var names of $crud_a to key and $crud_b to $crud_value so that its easier to understand.

Also, at the end of the $crud_complete you'll have an extra ||

like: red||green||

so after you jump out of the loop just cut it off with a:

substr($crud_complete,0,-2);

cheers
sm

Anon

Ah, wonderful.

It is amazing what you accomplish in two minutes, I 'attempt' to accomplish in five hours.

Thanks.