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
