Hi,
Thanks for your tip, and I am surprised that this could be done so easily.
Alice
> Date: Thu, 6 Nov 2008 08:11:48 -0800
> From: lists@xxxxxxxxx
> To: ajwei@xxxxxxxxxxxxx
> CC: phpster@xxxxxxxxx; php-general@xxxxxxxxxxxxx
> Subject: Re: Globals or Super Global Variables To Be Reused from For Loops
>
> Alice Wei wrote:
> > Hi,
> >
> >
> > Sorry, I cannot use that because I am supposed to turn the string into something that looks like
>
> Sounds like we are doing someones school work again.
>
> > regions.name LIKE '%47406' OR regions.name LIKE '%Detroit', which I had to fix $string3 variable to
> >
> > $string3="regions.name LIKE '%" . $stringChunk2[$j] . "'";
> >
> > The goal is that the $message variable would be only a $_POST['message'] variable so that the where clause can be generated dynamically.
> > The code I have above is part of my where clause in the full SQL statement I intend to
> > construct, which means I have to reuse this $string3 variable somewhere
> > else.
> >
> > This is what my global declaration looks like:
> >
> > if ($j <$count_chunk_2) {
> >
> > $string2= " OR ";
> > $string3=$string3.$string2;
> > global $string3;
> > }
> > else {
> > //Don't do anything
> > }
> > echo $string3;
> > }
> > echo $string3;
>
> against my better judgment, I believe this is what you are looking for.
>
> # Get your starting string
> $pieces = "47406|Detroit";
>
> # Break it into the parts you are looking to use
> $parts = explode("|", $pieces);
>
> # Empty temporary array
> $tmpHolder = array();
>
> # Loop through parts list
> foreach ( $parts AS $part ) {
>
> # Create a single statement and stuff it in your tmp array
> $tmpHolder[] = "regions.name LIKE '%{$part}'";
> }
>
> # Join all the parts together, placing an OR between each element.
> $string3 = join(' OR ', $tmpHolder);
>
>
> >
> > The last $string3 echo only gives me regions.name
> > LIKE '%Detroit' according to the current construct and not regions.name
> > LIKE '%47406' OR regions.name LIKE '%Detroit'. Is there something else I should do to have it give me the same output as the echo $string3 as I have had after the second to last curly brace?
> >
> > Thanks again for your help.
> >
> > Alice
> >
> >
> >> Date: Thu, 6 Nov 2008 10:22:44 -0500
> >> From: phpster@xxxxxxxxx
> >> To: ajwei@xxxxxxxxxxxxx
> >> CC: php-general@xxxxxxxxxxxxx
> >> Subject: Re: Globals or Super Global Variables To Be Reused from For Loops
> >>
> >> [snip]
> >> [/snip]
> >>
> >> Alice,
> >>
> >> The big problem here is that you are resetting the $string3 variable in the
> >> loop
> >>
> >> for ($j=0; $j<$count_chunk2; $j++) {
> >>
> >> $string3= $stringChunk2[$j]; // <<<------ resetting
> >> the value
> >> if ($j <$count_chunk_2) {
> >> $string2= " OR ";
> >> $string3=$string3.$string2;
> >> }
> >> else {
> >> //Don't do anything
> >> }
> >> echo $string3;
> >> }
> >>
> >>
> >> I am not sure of your goal since you have not stated it, but it certainly
> >> should be easier to just replace the PIPE with the OR
> >>
> >> $message = str_replace("|", " OR ", $message);
> >>
> >>
> >>
> >> --
> >>
> >> Bastien
> >>
> >> Cat, the other other white meat
> >
> > _________________________________________________________________
> > Express yourself with gadgets on Windows Live Spaces
> > http://discoverspaces.live.com?source=hmtag1&loc=us
>
>
> --
> Jim Lucas
>
> "Some men are born to greatness, some achieve greatness,
> and some have greatness thrust upon them."
>
> Twelfth Night, Act II, Scene V
> by William Shakespeare
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
_________________________________________________________________
Express yourself with gadgets on Windows Live Spaces
http://discoverspaces.live.com?source=hmtag1&loc=us
