Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. Can you post the output for each individual query?
  2. Define "put together".
  3. No, it's not what I needed... I need plaintext SQL queries.
  4. I have no idea what this means... obviously, you have to iterate through the records st!
  5. Sorry, you have lost me there, but thnaks for taking the time in doing this for me. P.S. i cannot find how to donate I just mean there are fields sthat still appear to be in need of interpolation... but I should be able to do it regardless.
  6. What's the final sql query?
  7. This really isn't a mysql question, it's a WAMP question.
  8. Sounds like it's not respecting your credentials.
  9. fenway

    I need info

    Yes, a cron is likely the best way to go... otherwise, maybe the event scheduler in 5.1, but I haven't used it.
  10. I am not sure I am following you, can you explain a little more about what you mean? Your field lengths seems very strict... why not be more lenient? That is how I want to do it, just store the image in a folder and have the DB store the URL and being to call it from their. How do I go about doing that. Is their anywhere you can point to read about this or explain this to me further? -Thanks Go about doyoing what? Uploading via PHP? You'll need to post that question in the appropriate forum.
  11. With a LEFT JOIN, all of the non-matching record columns will be set to null... that is, if there are no replies, in your case. So you can use IFNULL() to try and pull the latest reply date/time, otherwise, use the post date. Make sense?
  12. Well, why do you have variables you're not using?
  13. fenway

    help ....

    That should be impossible... no grants, no passwords.
  14. I guess a hint isn't enough...
  15. You should be using IFNULL().
  16. What are you talking about?
  17. No order by clause? How do you know what's "next"?
  18. Assuming you're hashing something of reasonable length, MD5() should give you something psuedo-unique enough.
  19. I would add a custom error handler, log all of the info, watch it for a while... this shouldn't happen without a proper DB warning.
  20. Well, you can SELECT INTO OUTFILE...
  21. fenway

    help ....

    Have you read this?
  22. How are messages / newfeeds related?
  23. I don't understand.
  24. Wow, that's a terrible table design... re-think this.
  25. More importantly, you're not quoting your string literals.
×
×
  • 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.