On Wed, January 24, 2007 12:53 am, Don wrote:
> zips are fixed, but my clients have districts that I want to be
> searched by
> zip+4. Each client will have a different district with different zips
> per
> district.
> They are to input the zips that are within their district when they
> sign up,
>
On Tue, January 23, 2007 11:49 pm, Don wrote:
> I appreciate all the input. I would definitely like to use a separate
> table
> for the zips, but I cannot figure out how make the form that stores
> them
> user friendly each entry can have any number of zips - from many
> to just
> a few.
>
> Al
On k, 2007-01-23 at 22:49 -0700, Don wrote:
> On k, 2007-01-23 at 00:58 -0800, Jim Lucas wrote:
> > Németh Zoltán wrote:
> > > On k, 2007-01-23 at 19:46 +1100, chris smith wrote:
> > >> On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
> > >>> On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
>
> I appreciate all the input. I would definitely like to use a separate
table
> for the zips, but I cannot figure out how make the form that stores them
> user friendly each entry can have any number of zips - from many to
just
> a few.
>
> Also, the site is in development, so there is no ex
I appreciate all the input. I would definitely like to use a separate table
for the zips, but I cannot figure out how make the form that stores them
user friendly each entry can have any number of zips - from many to just
a few.
Also, the site is in development, so there is no existing data..
On k, 2007-01-23 at 00:58 -0800, Jim Lucas wrote:
> Németh Zoltán wrote:
> > On k, 2007-01-23 at 19:46 +1100, chris smith wrote:
> >> On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
> >>> On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
> Don wrote:
> > I have a db field that contain
On 1/23/07, Jim Lucas <[EMAIL PROTECTED]> wrote:
Németh Zoltán wrote:
> On k, 2007-01-23 at 19:46 +1100, chris smith wrote:
>> On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
>>> On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
Don wrote:
> I have a db field that contains zip codes
On k, 2007-01-23 at 00:58 -0800, Jim Lucas wrote:
> Németh Zoltán wrote:
> > On k, 2007-01-23 at 19:46 +1100, chris smith wrote:
> >> On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
> >>> On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
> Don wrote:
> > I have a db field that contain
Németh Zoltán wrote:
On k, 2007-01-23 at 19:46 +1100, chris smith wrote:
On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
Don wrote:
I have a db field that contains zip codes separated by comas.
I am trying to get php to return all of the
On k, 2007-01-23 at 19:46 +1100, chris smith wrote:
> On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
> > On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
> > > Don wrote:
> > > > I have a db field that contains zip codes separated by comas.
> > > >
> > > > I am trying to get php to return al
On 1/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote:
On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
> Don wrote:
> > I have a db field that contains zip codes separated by comas.
> >
> > I am trying to get php to return all of the rows that contain a particular
> > zip code.
> >
> >
> >
> > $q
On h, 2007-01-22 at 22:53 -0800, Jim Lucas wrote:
> Don wrote:
> > I have a db field that contains zip codes separated by comas.
> >
> > I am trying to get php to return all of the rows that contain a particular
> > zip code.
> >
> >
> >
> > $query = "SELECT * FROM info WHERE MATCH (partialZIP
Don wrote:
I have a db field that contains zip codes separated by comas.
I am trying to get php to return all of the rows that contain a particular
zip code.
$query = "SELECT * FROM info WHERE MATCH (partialZIP) AGAINST ('$zip')";
try this
$query = "SELECT * FROM info WHERE column LIKE '
Don wrote:
> I have a db field that contains zip codes separated by comas.
>
> I am trying to get php to return all of the rows that contain a particular
> zip code.
>
>
>
> $query = "SELECT * FROM info WHERE MATCH (partialZIP) AGAINST ('$zip')";
>
> $result = mysql_query($query)
>
> or die
Don wrote:
I appreciate your quick response, but I think the problem I'm having is in
the query. Is WHERE MATCH () the proper format to use for getting multiple
rows from the DB? Or is there something else I'm missing?
Please don't top post, it's hard to follow what's going on and who's
replie
I appreciate your quick response, but I think the problem I'm having is in
the query. Is WHERE MATCH () the proper format to use for getting multiple
rows from the DB? Or is there something else I'm missing?
Don wrote:
> I have a db field that contains zip codes separated by comas.
>
> I am tryi
Don wrote:
I have a db field that contains zip codes separated by comas.
I am trying to get php to return all of the rows that contain a particular
zip code.
$query = "SELECT * FROM info WHERE MATCH (partialZIP) AGAINST ('$zip')";
$result = mysql_query($query)
or die ("could not connect t
17 matches
Mail list logo
