NYCPHP Meetup

[harvey]

That worked.

I just added $zippers[]=$key to the foreach loop and then used a tweak of 
your SELECT.

$query_zipsss = "SELECT * FROM organizations WHERE org_zip IN (". 
join(",",$zippers) . ")";

Thanks very much!



At 04:48 PM 6/21/2005, drydell at att.net wrote:

>IN is a standard construct in every DB engine I can think of... IN expects 
>a comma delimited list:
>
>SELECT cols FROM table WHERE zip in (11111, 22222, 33333)
>
>with PHP, you can do something like:
>
>$zips = array(11111, 22222, 33333);
>
>$rs = mysql_query('SELECT cols FROM table WHERE zip in ('.join(',', 
>$zips).')');
>
>-------------- Original message from "Chris Bielanski" 
><Cbielanski at inta.org>: --------------
>
> > AFAIK, in MySQL <=4.x you'll have to do a code-aggregation:
> > [PHP]
> > $result = array();
> > foreach ($zips as $key=>$val) {
> > $result[] = $val;
> > $rs = mysql_query("SELECT * FROM organizations WHERE org_zip = $val");
> > if(@mysql_hum_rows($rs) != 0)
> > while($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
> > $result[$val][] = $row;
> > }
> > }
> >
> > var_dump($result);
> > [/PHP]
> >
> > In MySQL 5, you could do an IN SELECT or similar aggregation.
> >
> > Thanks,
> > Chris Bielanski
> > Web Programmer,
> > International Trademark Association,
> > 655 Third Avenue, 10th Floor
> > New York, NY 10017-5617 USA
> > +1 (212) 642-1745, f: +1 (212) 768- 7796
> > mailto:cbielanski at inta.org, www.inta.org
> > INTA -- 125 Years of Excellence
> >
> >
> > > -----Original Message-----
> > > From: talk-bounces at lists.nyphp.org
> > > [mailto:talk-bounces at lists.nyphp.org] On Behalf Of harvey
> > > Sent: Tuesday, June 21, 2005 4:24 PM
> > > To: NYPHP Talk
> > > Subject: [nycphp-talk] Mysql Selects
> > >
> > > Hello,
> > >
> > > I've got code that queries the 'zipcode' tables in a database
> > > and finds the zips that are within X miles of Y zip code. Works fine.
> > >
> > > <?php
> > > $z = new zipcode_class;
> > > $zips = $z->get_zips_in_range($zipcode,$distance);
> > > if (empty($zips))
> > > { echo "Error: " . $z->last_error; }
> > > else { foreach ($zips as $key => $value) { echo
> > > "$key is $value miles from
> > > $zipcode.
>"; }; } ?>
> > >
> > > Now I want to query the 'organization' tables and return all
> > > the orgs that have one of the zips found above. But I'm not
> > > sure how to go about it.
> > > Something like the following (which I know is incorrect)?
> > >
> > > SELECT * FROM organizations WHERE org_zip IN ($zips)
> > >
> > > Thanks in advance for your help...I'm sure it's some very
> > > basic concept I'm missing.
> > >
> > > Harvey
> > >
> > > _______________________________________________
> > > New York PHP Talk Maili ng List
> > > AMP Technology
> > > Supporting Apache, MySQL and PHP
> > > http://lists.nyphp.org/mailman/listinfo/talk
> > > http://www.nyphp.org
> > >
> > _______________________________________________
> > New York PHP Talk Mailing List
> > AMP Technology
> > Supporting Apache, MySQL and PHP
> > http://lists.nyphp.org/mailman/listinfo/talk
> > http://www.nyphp.org
>
>_______________________________________________
>New York PHP Talk Mailing List
>AMP Technology
>Supporting Apache, MySQL and PHP
>http://lists.nyphp.org/mailman/listinfo/talk
>http://www.nyphp.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20050621/b359957c/attachment.html>