$getme = $q;
$qArray = explode(" ", $getme);
$num = count($qArray);
$sql = "SELECT * FROM `hyperlinks` WHERE 1";
for ($i = 0; $i < $num; $i++)
if (strlen($qArray[$i]) > 0)
$sql .= " AND `keywords` LIKE '%".$qArray[$i]."%'";
$sql .= " ORDER BY `id` ASC LIMIT 0, 30";
hehe its works (o; thanks
http://www.philipsdomain.com/hyperlinks/search.php (o;
Thanks buddy (o;
----- Original Message -----
From: "Hank Marquardt" <[EMAIL PROTECTED]>
To: "Philip J. Newman" <[EMAIL PROTECTED]>
Cc: "Hank Marquardt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 07, 2002 10:54 AM
Subject: Re: [PHP] Help with a search array.
> 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
