Jump to content

fenway

Staff Alumni
 View Profile  See their activity

  • Posts

    16,168

  • Joined

  • Last visited

  • Days Won

    4

 Content Type 

Everything posted by fenway

  1. fenway
    It's a rather sorry state of affairs, IMHO.
  2. fenway
    Of course you can run multiple statements.
  3. fenway
    Try here.
  4. fenway
    Sounds like you want to group by some arbitrary time period....
  5. fenway
    How about table structure and some queries?
  6. fenway
    I don't follow.
  7. fenway
    Or double-post. Topic locked.
  8. fenway
    You're talking about php syntax errors, not mysql problems.
  9. fenway
    Wait.. what doesn't work?
  10. fenway
    MySQL has plenty of data types -- use the right ones.
  11. fenway
    What's a "user field"?
  12. fenway
    So? Use * or specify the fields you want... what doesn't work?
  13. fenway
    If you're talking about php syntax, this is the wrong place.
  14. fenway
    Yikes... you're missing a ON condition for your JOIN.
  15. fenway
    I only see a single statement, so I don't see where you're getting back anything from a second table.
  16. fenway
    You mean with MIN() and mAX()?
  17. fenway

    sql query

    fenway replied to crazyglue71's topic in MySQL Help

    Show us the actual query, and tell us what doesn't work.
  18. fenway
    I don't follow -- you're asking why you're getting duplicate exhibitionname fields/
  19. fenway
    Conditions can't be set up as anything -- it's your table that needs to support many-to-many
  20. fenway
    And next time, don't post entire scripts unless you're asked to.
  21. fenway
    Of course, %term% covers all 4 cases.
  22. fenway
    You have no join conditions!
  23. fenway
    First problem -- that's not a valid mysql date format -- use STR_TO_DATE().
  24. fenway

    SELECT not in

    fenway replied to Matrixkid's topic in MySQL Help

    Ah... then you need a LEFT JOIN, or NOT EXISTS.
  25. fenway
    If you'd like to rank partial substring matches by distances from string position 0, that's not hard to do in application code.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.