Addressed to: Rick St Jean <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Rick St Jean <[EMAIL PROTECTED]> Tue, 06 Mar 2001
01:47:05 -0500
A good way to do what you are asking is a combination of the last two
suggestions...
if( count( $Area )) { # Don't do anything if there are no entries
reset( $Area );
# Handle the first one, with no 'or'
list( , $Value ) = each( $Area );
$String = "(Area='$Value')";
# Handle the rest with a leading 'or'
while( list( , $Value ) = each( $Area )) {
$String .= " or (Area='$Value')";
}
}
>
> I have just started with php a few days ago but in the book that I am
> reading it
> uses a foreach loop that is specifically for arrays.
>
>
> foreach($Area as $key=>$value)
> {
> your concatination string here
> }
>
> Rick
>
> At 04:45 PM 3/6/01 +1030, you wrote:
> >On Tue, 6 Mar 2001 15:50, [EMAIL PROTECTED] wrote:
> > > A problem of inexperience...
> > >
> > > I am trying to store an array in mysql. I obtain the array like so--
> > >
> > > $partcount = count($Area);
> > > reset($Area);
> > > for ($i = 0; $i < $partcount; $i++){
> > > $key = key($Area);
> > > $val = $Area[$key];
> > > $string1 .= $val . "\') or (Area=\'";
> > > next($Area);
> > > }
> > >
> > > This results, with a bit of coaxing, in an array like this one --
> > >
> > > +-----------------------------------------------------+
> > >
> > > | Area |
> > >
> > > +-----------------------------------------------------+
> > >
> > > | (Area='1') or (Area='2') or (Area='3') or (Area='') |
> > >
> > > +-----------------------------------------------------+
> > >
> > > Everything is falling into place, *except* these last thirteen
> > > characters --
> > >
> > > or (Area='')
> > >
> > > And that's what I'd like to eradicate.
> > >
> > > Tips, suggestions, especially outright code greatly appreciate.
> > >
> > > Thanks,
> > > Robert
> > > p.s.-- I have ordered the Friedl book on Regular Expressions. Hoping it
> > > will enlighten me for the future
> >
> >My suggestion would be to not create the empty reference in the firast
> >place :-)
> >
> >Before starting your loop (but after checking there is something to work
> >with) use the first element of the arra to create the (Area='1') then you
> >can loop through the rest of the array, starting with $i = 1 and create
> >
> > or (Area='$val')
Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
