I think it does what you want .. explode returns an array, so then you
iterate the array and build your 'like' clauses.
On Thu, Mar 07, 2002 at 10:33:54AM +1300, Philip J. Newman wrote:
> So basicly what your saying is this ...
>
> I have to split the words into
>
> into the different veriables ... count the veriables and then put them into
> a loop in the mysql thingie.
>
> $words = explode(" ",$keywords);
>
> don't give me veriabe1 verible2 etc
>
> ----- Original Message -----
> From: "Hank Marquardt" <[EMAIL PROTECTED]>
> To: "Philip J. Newman" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, March 07, 2002 10:21 AM
> Subject: Re: [PHP] Help with a search array.
>
>
> > $words = explode(" ",$keywords);
> >
> > foreach($words as $word) {
> > Create your sql.
> > }
> >
> > .. or $words[0] = 'first word', $words[1]='second word'
> >
> > That will do what you asked, though I suspect you'll be back when you
> > want to add quoted phrases, such that you could have $q = green eggs
> > "and ham" ... then retaining 'and ham' as a token by itself.
> >
> > At that point you'll probably want to delve into a regex to solve the
> > problem.
> >
> > On Thu, Mar 07, 2002 at 10:08:00AM +1300, Philip J. Newman wrote:
> > > heres my example:
> > >
> > > I want to break up the search words in a string.
> > >
> > > eg: $q = green eggs
> > >
> > > would like that to be
> > >
> > > $q1 = green
> > > $q2 = eggs
> > >
> > > ... then ....
> > >
> > > the mysql process
> > >
> > > $sql = "";
> > >
> > > for ($i = 0; $i < $num; $i++)
> > > if (strlen($getme_arr[$i]) > 0)
> > > $sql .= " '%".$getme_arr[$i]."%'";
> > >
> > > $sql .= " ORDER BY `id` ASC LIMIT 0, 30";
> > >
> > > ... This should send to my sql ...
> > >
> > > SELECT * FROM `hyperlinks` WHERE 1 AND `keywords` LIKE "green" AND
> `keywords` LIKE "eggs" ORDER BY `id` ASC LIMIT 0, 30
> > >
> > > How ever it really down't want to work. Any Suggestions
> > >
> > > Philip J. Newman
> > > PhilipNZ :: Design Solutions
> > > http://www.philipnz.com/
> > > [EMAIL PROTECTED]
> > > ICQ# 20482482
> > > +64 25 6144012
> >
> > --
> > Hank Marquardt <[EMAIL PROTECTED]>
> > http://web.yerpso.net
> > GPG Id: 2BB5E60C
> > Fingerprint: D807 61BC FD18 370A AC1D 3EDF 2BF9 8A2D 2BB5 E60C
> > *** Web Development: PHP, MySQL/PgSQL - Network Admin: Debian/FreeBSD
> > *** PHP Instructor - Intnl. Webmasters Assn./HTML Writers Guild
> > *** Beginning PHP && PHP II -- Starting March 25, 2002
> > *** See http://www.hwg.org/services/classes
> >
> > --
> > 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
>
--
Hank Marquardt <[EMAIL PROTECTED]>
http://web.yerpso.net
GPG Id: 2BB5E60C
Fingerprint: D807 61BC FD18 370A AC1D 3EDF 2BF9 8A2D 2BB5 E60C
*** Web Development: PHP, MySQL/PgSQL - Network Admin: Debian/FreeBSD
*** PHP Instructor - Intnl. Webmasters Assn./HTML Writers Guild
*** Beginning PHP && PHP II -- Starting March 25, 2002
*** See http://www.hwg.org/services/classes
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
