Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

fenway last won the day on April 3 2019

fenway had the most liked content!

About fenway

  • Birthday 07/08/1979

Profile Information

  • Gender
    Male
  • Location
    Toronto, ON

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

fenway's Achievements

Advanced Member

Advanced Member (4/5)

21

Reputation

  1. Wait -- you just want to show the first 5 awards a given member has? Simple JOIN with LIMIT.
  2. 5.1 has a event scheduler... but cron really is the way to go.
  3. You'll need a temporary table to do that -- but given the complexity of your query, I think there's something fundamentally flawed.
  4. What's more, if this has to be done by "tomorrow morning", it sounds like a homework assignment.
  5. Yes, except you can't merge * and GROUP BY.
  6. Well, then use something unique for another table, and use BETWEEN.
  7. Then what is unique in that table? Something numeric, perhaps?
  8. To get your friend's friends, you'll need to join twice -- do you have this query working?
  9. well, you don't appear to have a UID on the worldcitylist table...
  10. You'll have to batch your updates -- based on UIDs, not random DB order and LIMIT. But you really should check out those warnings.
×
×
  • 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.