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
    chemical1, 2, 3 shouldn't be columns... they should be rows.
  2. fenway

    mysql query

    fenway replied to chaiwei's topic in MySQL Help

    There are unorthodox ways to get that output with ORDER BY, HAVING and DISTINCT, but it's a hack.
  3. fenway
    That's because you need to unique-ify the journey first, then join that result.
  4. fenway
    Why not ON DUPLICATE KEY UPDATE?
  5. fenway
    Sorry, what's the rest?
  6. fenway
    I can't even begin to make sense of that.
  7. fenway
    And next time, post in the php board.
  8. fenway
    Or you can do this in application code as long as you're the only one accessing the table.
  9. fenway
    Why can't you simply run through the result set and count yourself?
  10. fenway
    You can't use an INDEX with LIKE.
  11. fenway
    Well, then you'll have to debug each part of that expression.
  12. fenway

    GROUP BY Regex

    fenway replied to e1seix's topic in MySQL Help

    You can use SUBSTRING_INDEX() or LOCATE(), but only if you know *exactly* how all of your data is formatted.
  13. fenway
    That would be better if if actually used JOIN, not commas.
  14. fenway
    I don't follow... why use a search if your search would simply find everything?
  15. fenway
    It can't work ... it just look like it works.
  16. fenway
    OK... but the only part that has to do with mysql is the query with the expiration range.
  17. fenway
    Are you sure you're not quoting it by accident?
  18. fenway
    Even if you "fake" it by wrapping it in a SELECT * FROM ( .... ) ?
  19. fenway
    Don't use unique IDs as counters.
  20. fenway
    Just run a query beforehand to figure it out, then build the string yourself -- easy as pie.
  21. fenway
    A duplicate on a key? Where is the index?
  22. fenway
    Your strings aren't quoted.
  23. fenway
    It's this just a simple query with a where clause?
  24. fenway
    There is lots of information to share -- from the php manual.
  25. fenway
    You're right, TLDR, especially with all that code. But is the output of the queries suspect?
×
×
  • 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.