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
    Did you try writing a JOIN?
  2. fenway
    I guess you could round-robin all 10 users.
  3. fenway
    Post the table structure, and the query.
  4. fenway
    Why are you running this query? Is this a one-off DB cleanup? Otherwise, don't store the same value in 2 places.
  5. fenway
    What are you trying to achieve?
  6. fenway
    Then I don't understand what you're asking.
  7. fenway
    DESCRIBE will work too, pre v5.
  8. fenway
    This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=344334.0
  9. fenway
    That's just lazy -- that's what loops are for. In the time you spent "googling all day", you could have been done 30 times.
  10. fenway
    You mean like "parent_uid"?
  11. fenway
    Don't bump a thread twice in one day, let alone twice in 30 minutes.
  12. fenway
    Sorry, I'm not windows IT guy -- I'm knowledgeable, but not about a system that I can't sit in front of.
  13. fenway
    If you don't know, how can we?
  14. fenway
    That means you have parallel arrays -- that's what a hash is for.
  15. fenway
    Clicking links has nothing to do with mysql.
  16. fenway
    What?
  17. fenway
    Never change an auto-incremented value -- EVER.
  18. fenway

    query optimization

    fenway replied to jd22's topic in MySQL Help

    Explain that distinct requirement again...?
  19. fenway
    Usually a "run as administrator" game.
  20. fenway
    Yes, that's still an issue.
  21. fenway
    Better == Pythagoras.
  22. fenway
    Yup, just missing the actual INSERT.
  23. fenway
    You need HAVING -- and don't use great circle distance -- it's just unnecessarily slow.
  24. fenway
    That's usually a windows user account permission game.
  25. fenway

    query optimization

    fenway replied to jd22's topic in MySQL Help

    It's not optimized because you're not using JOINs.
×
×
  • 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.