Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. I meant without all of those subqueries.
  2. Well, if you want to be lazy, you can use GROUP_CONCATS.
  3. I don't know what you think you mean when you say "debug turned on". Add print statements.
  4. Please don't ask for that -- it's quite clear there is no opening quote.
  5. 1,2 and 3 should only require a single join.
  6. 1st) don't follow. 2nd) a JOIN. Following the posting rules will help.
  7. Sorry -- I read "instead" not "along".
  8. error_reporting(E_STRICT) is your friend.
  9. There's a sticky on this forum that will tell you what kind of information we need from you.
  10. You can never re-generated the start and end times with the difference alone.
  11. Show us what output you're expecting.
  12. Stop posting all of your code. Post your queries (raw queries) and mysql_error() output.
  13. Never a good idea to throw out raw data.
  14. I would have flipped that around, but yes.
  15. But, but, mother's day is this Sunday! Surely it's not the time to remove parents! :-P I sit corrected.
  16. @newphpcoder -- last warning -- stop posting new topics for the same issue.
  17. UPDATE without a WHERE clause? Dangerous.
  18. You need to debug your subroutine to see why you're getting nothing.
  19. Of course not -- but I've seen multiple databases be much worse.
  20. If you're still have difficulties, post the actual error messages.
  21. But then, of course, one of the values won't have changed.
  22. I don't follow.
  23. Did you specify "single-transaction"? Otherwise, your snapshot is inconsistent.
×
×
  • 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.