Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. That error isn't from mysql.
  2. Assuming you only want (a) a single category per item, and (b) no subcategories, then yes.
  3. Of course there's an easier way -- use a DB wrapper to write the queries for you, and pass it a hash.
  4. I don't know what a "large query" is, and why it's a problem.
  5. Sorry -- never worked with NDB.
  6. fenway

    Easy question!

    First, you can change the auto-increment starting value. Second, you really don't need to change UIDs -- ever.
  7. There could be thousands of matching rows -- don't get data just to throw it out.
  8. Are you sure it's using that my.ini file?
  9. Browsers need to be told about UTF-8, as well as your import.
  10. What are you trying to do? That looks like it should be a JOIN.
  11. So you have 0, 1, or 2 files?
  12. Welcome to the club.
  13. If you want all the rows _and_ an aggregate expression, you'll need a subquery.
  14. You have dozens of queries -- find the one that causes the error, and tell us.
  15. Sounds like the OP wants an UPDATE.
  16. Don't post your DB credentials to the world -- and I don't know what "offline" means, anyway.
  17. Sounds like the OP is talking about fields, not records.
  18. Do this in 2 parts -- grab the top 10 scores, and then join back to grab anyone with said scores.
  19. If your DB equalities are case-sensitive, that means you're working with a binary collation.
  20. Then you want more than 10.
  21. Please post your solution.
  22. First, it gives you a line number. Second, "$end" doesn't show up the code you posted.
  23. I figured as much -- but I've seen 80kb attachements recently. As mentioned above, that string isn't quoted at all.
  24. You need to be able to debug code yourself -- not with someone else's tools.
×
×
  • 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.