Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. Then post the solution.
  2. Are you getting the right results? I only see a single "LIKE".
  3. You can use the information_schema tables in mysql 5...
  4. That's going to be impossible... why not just JOIN them to have the relationship captured in each row?
  5. an ORDER BY clause will make them alphabetical... the layout has nothing to do with mysql.
  6. Failed how?
  7. Well, you can checksum the tables for starters...
  8. You can use FIND_IN_SET() to find the "3"... but I'm not sure what else you mean.
  9. Wait.. which statment throws that error?
  10. What does "not loading" even mean?
  11. FIXED AND SOLVED -- how?
  12. Well, what about $query?
  13. Drop the parens for the if... otherwise, it references the IF() function.
  14. that is latin1...
  15. We can't guess your statement or your table structures.
  16. And you've read the sticky in the child board already?
  17. OMG, seriously?
  18. Are these many-to-many relationships? You might actually be "joining" in multiple records.
  19. Isn't the second query covered by the first one?
  20. Then post the solution, please!!!
  21. Yes, but why not use BETWEEN?
  22. It means just that... there's a deadlock that timed out. No problem... just restart the transaction again.
  23. fenway

    SQL, tranfer?

    INSERT INTO... SELECT WHERE???
  24. Echo the actual statement being sent to the server.
×
×
  • 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.