I can make this just a little easier.. try this
$query = "SELECT * FROM mytable WHERE t_state_id_state in ('" .join("', '",
$state). "')";
if $state happens to be the name of the array that is passed from the
multi-select
Jim Lucas
www.bend.com
----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'John Fishworld'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 10:07 AM
Subject: RE: [PHP] Array Question
> $n =sizeof($state);
>
> $srch = "";
> while( $x=0; $x<$n; $x++)
> {
> ... do something with array element $state[$x] ...
> $srch .= $state[$x].", ";
> }
> $srch = rtrim($srch,", ");
> $query = "SELECT * FROM mytable WHERE t_state_id_state in ($srch)";
>
> -----Original Message-----
> From: John Fishworld [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 11:51 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Array Question
>
>
> I have some multiple select boxes in a form
> ie
> <SELECT name="state[]" multiple size=5 style="width:360;">
> <option value="all">all Regions </option>
> <option value="16">Region19 </option>
> <option value="14">Region14</option>
> <option value="5">Region15</option>
>
> these then get passed and I want to use them in mysql query
>
> blah blah
> WHERE
> (t_state_id_state = $state[0])
>
> Whats the best way of finding out how many items are in my array ?
> And how can I step through the ones the exist ?
> And can I only use LIKE % when my value is all ?
>
> thanks
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
