Thanks everyone for your attention but still at the 1st step. What I
want (not need but want) is to keep my code as short as possible for
future referencing from others. Looking at some on-line manuals I found
this just now:

(^|[^a-zA-Z])foo([^a-zA-Z]|$)

which Works if you want to find "foo" in "foo bar", "bar foo", "bar foo
bar", or "foo" but NOT in "foobar" or "barfoo".

I guess that just by taking out the *foo* word between them can make it
work for quite a useful wildcard. What do you think pals?

C.

> -----Original Message-----
> From: Richard Black [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 8:06 AM
> To: 'CÚsar Aracena'
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP] Re: Wildcard
> 
> Theres no point selecting on a value if they've not specified one. The
> following code should generate a valid query, assumin that the default
> value for each value select value is an empty string:
> 
> $query = "SELECT * FROM table_name ";
> 
> $where_string = "WHERE ";
> $and = "";
> if ($select1 != "")  {
>   $where_string .= $and."col1 = '".addslashes($select1)."'";
>   $and = " AND ";
>   }
> if ($select2 != "")  {
>   $where_string .= $and."col2 = '".addslashes($select2)."'";
>   $and = " AND ";
>   }
> if ($select3 != "")  {
>   $where_string .= $and."col3 = '".addslashes($select3)."'";
>   $and = " AND ";
>   }
> 
> if ($where_string != "WHERE ")  {
>   $query .= $where_string;
>   }
> 
> And then run the query as normal.
> 
> HTH,
> 
> Richy
> 
> ==========================================
> Richard Black
> Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com
> Tel: 0141 435 3504
> Email: [EMAIL PROTECTED]
> 
> -----Original Message-----
> From: CÚsar Aracena [mailto:[EMAIL PROTECTED]]
> Sent: 10 July 2002 11:50
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [PHP] Re: Wildcard
> 
> 
> Ok. Maybe I didn't express myself well (must be the 3-4 days awake ;)
> 
> No, I don't have an example on-line 'couse this is something I'll
start
> doing in a few days or hours. Well, just what it will probably be the
> search options at: http://www.icaam.com.ar/proyects/os-seek/ which I
> posted a few hours ago.
> 
> What I want, is to let the visitor search for an OS developer by
> WORK-AROUND and/or LANGUAGE and/or LOCATION and have just ONE static
> query to handle all this. The thing is that if I make the query like
> this:
> 
> SELECT * FROM table_name WHERE col1 = $elect1 AND col2 = $select2 AND
> col3 = $select3
> 
> I think maybe the script will go nuts if no option was selected
> (remember the and/or?). So I figured out that maybe by telling HTML
that
> the default value of each SELECT box is % (or any kind of wildcard)
the
> query might run as predicted. Does this makes ant sense now?
> 
> Please go to the site I've mentioned before and afterwards (if have
the
> time and will) go back a couple of dozens post back and read the post
> called *MORE WORK FOR US I HOPE* so you have a more clear
understanding
> of what my need will be.
> 
> Thanks, C.
> 
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 10, 2002 7:27 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Re: Wildcard
> >
> > why put in your query you want to look for an value .. if they don't
> want
> > to
> > look for it ?..
> >
> >
> > vins writes:
> >
> > > Shit.....
> > > Doesn't really make sense
> > > Sorry... I probably don't understand
> > >
> > > do you have an online example.
> > >
> > >
> > > "CÚsar aracena" <[EMAIL PROTECTED]> wrote in message
> > > 000101c227fb$74eed940$68ed0dd1@gateway">news:000101c227fb$74eed940$68ed0dd1@gateway...
> > > Hi all.
> > >
> > > I'm trying to figure out how to do a search trough a MySQL db
using
> LIKE
> > > or = but the thing is that I have 3 select boxes from where to
> choose
> > > the search terms. Can I use something like a wildcard instead of
> making
> > > several IF statements like this?
> > >
> > > SELECT * FROM table_name WHERE col1 = value1 AND col2 = value2 AND
> col3
> > > = %
> > >
> > > % goes for an unselected select box (default value = %) in case
the
> user
> > > doesn't want to make an *advanced* search, so it fetches all rows
> which
> > > does contains values 1 & 2.
> > >
> > > Thanks,
> > >
> > >  <mailto:[EMAIL PROTECTED]> Cesar Aracena
> > > CE / MCSE+I
> > > Neuquen, Argentina
> > > +54.299.6356688
> > > +54.299.4466621
> > >
> > >
> > >
> > >
> > >
> > > --
> > > 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
> 
> 
> 
> --
> 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



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to