Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. Of course, if you're just formatting for output, don't ever store this.
  2. I'm sure something happens -- if you get a blank page, that's something else. Define "nothing".
  3. You may have manually created a UID with an extra zero -- auto-increment won't fill spaces.
  4. So have you proven you can actually connect?
  5. MEMORY is great for throw-away data -- caching included.
  6. Well, that's in the where clause -- what's not working.
  7. fenway

    date_format

    Maybe if you actually showed us the error?
  8. Wow, you resurrected a really old thread...
  9. Likely won't have an opportunity for a few days....
  10. Don't worry about the size -- your users aren't uploading gigs of custom lists. If you want to query individual values, you'll have to put each into it's own field -- which will be really ugly, and much, much slower.
  11. Then you don't know where to look -- see here.
  12. Drop all of those quotes.
  13. What's wrong is that you're unfamiliar with how variable interpolation works. You need to be inside double quotes -- but, of course, you may be opening yourself to SQL injection, depending on where $sterm comes from.
  14. Or read the stickies.
  15. That's a terrible idea -- performance hell.
  16. The only consideration is that the TEXT field may cause performance issues, depending on what else you put into that table, so you might have to break it out. But if you're not querying its contents, why not have it all together? Alternatively, you can store it on disk, but that seems like overkill.
  17. Echo the entire query -- but you'll get in less trouble if you use IN().
  18. There must be countless tutorials on this -- no different than an image.
  19. Oh, now I understand what you want. At first glance, you may have to use user-variables to handle this -- which means sorting the result set by ( dog, date ) -- and simply checking the difference for a given dog for each row. I'm just heading out, so I don't have time to draft the query, but basically, you reset the prev date if the dog is different, otherwise, check the prev vs current date, and mark accordingly.
  20. And why can't you just group on the DAYOFWEEK()?
  21. Drop one inner join at a time, see what's failing.
  22. Just be careful about the max_length of group-concat.
  23. I don't see why you can't have a type field in your addresses table with a unique index across the customer UID.
  24. See what this returns: SELECT s.dog, COUNT(s.dog) AS entries, t.date, DATEDIFF( MAX( date ) , MIN( t.date ) ) FROM singles s INNER JOIN tournament t ON t.enumber = s.event GROUP BY s.dog
  25. Sorry, I don't follow.
×
×
  • 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.