NYCPHP Meetup

[Phil Powell]

I corrected that a long time ago, actually!

Phil
  ----- Original Message ----- 
  From: David Rydell 
  To: NYPHP Talk 
  Sent: Monday, September 22, 2003 11:12 AM
  Subject: RE: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


  ... and s.nnet_produkt_storrelse.id  should probably be s.nnet_produkt_storrelse_id 
    -----Original Message-----
    From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org]On Behalf Of David Rydell
    Sent: Monday, September 22, 2003 10:23 AM
    To: NYPHP Talk
    Subject: RE: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


    there have been many responses to this, but nobody seemed to notice that Phil is missing the underscore in sv.nnet_produkt_storrelse_id 

    the error message is quite specific about not understanding what 'id' is... 
      -----Original Message-----
      From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org]On Behalf Of Phil Powell
      Sent: Sunday, September 21, 2003 12:54 PM
      To: NYPHP Talk
      Subject: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


      Ok guys, here we go again!

      SELECT s.nnet_produkt_storrelse_navn 
      FROM nnet_produkt_storrelse s, nnet_produkt_varegruppe v, nnet_storrelse_varegruppe_assoc sv 
      WHERE s.nnet_produkt_storrelse.id = sv.nnet_produkt_storrelse id 
       AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id 
       AND sv.nnet_produkt_varegruppe_id IN (
         SELECT nnet_produkt_varegruppe_id 
         FROM nnet_produkt_varegruppe
         WHERE nnet_produkt_varegruppe_code =  'FLU17' 
       )
       AND s.nnet_produkt_storrelse_id > 1

      This produces the following error:

      You have an error in your SQL syntax near 'id AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id AND sv.nnet_' at line 1

      I don't see anything wrong with this query, it's standard inner SELECT stuff!  I need help... again!

      Phil


------------------------------------------------------------------------------


  _______________________________________________
  talk mailing list
  talk at lists.nyphp.org
  http://lists.nyphp.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030922/f2c417ce/attachment.html>