Jump to content

Jessica

Staff Alumni
  • Posts

    8,968
  • Joined

  • Last visited

  • Days Won

    41

Everything posted by Jessica

  1. This is the best I can come up with given the info you've provided. SELECT item_detail.price as totalPrice, item_detail.track_item_id, tracked_item.user_item item_detail.price as myprice FROM tracked_item LEFT JOIN item_detail ON b.track_item_id=tracked_item.id LEFT JOIN item_detail item_detail_2 ON item_detail_2.itemID = tracked_item.user_item WHERE ???.itemStatus='Active' AND item_detail.user_id='$uid' GROUP BY item_detail.track_item_id If that doesn't do what you wanted, you'll need to post your tables and explain WHAT you want.
  2. Do you know correct syntax for a query? If not, look it up in the manual. Edit: you changed your post, now the syntax is correct. Post your updated query and error.
  3. That's still not the correct syntax for a query. Why not use a join, anyway?
  4. The comment on there "There is also a difference between NULL === $var and $var === NULL" Annoys me. There is a difference? What is it? If you already figured out that there's a difference, post your work, man!
  5. (select price as myprice where itemID=a.user_item) This subquery is incomplete.
  6. I used Natural Docs and really liked it.
  7. Well, I gave you a suggestion to debug it, you'll have to set the user's lock time to be in the future again if you want to test it.
  8. Time has passed since then. At this point in time, according to your code, the user shouldn't be locked out any more.
  9. time() now is 1346795539 (fixed) So 1346794857 is no longer greater than time().
  10. Can you add a die() on line 108 with the two variables, that will determine if the problem is the variables you're comparing, or with CI handling the output array.
  11. See line 98. $current_gmt_time = time();
  12. What you're describing doesn't make sense. No, you can't have an iframe within an iframe.
  13. I'm confused about what you're trying to accomplish. If you're trying to get a list of how many users are in each forum, you would do SELECT count(in_forum), in_forum FROM '.$db->prefix.'online GROUP BY in_forum
  14. You haven't posted anything besides the if(){, we can't help without seeing the code. As soon as I hit submit, I saw the pastebin link. Looking at it now.
  15. http://forums.phpfreaks.com/index.php?topic=200925.0
  16. *shrug* I hate Java personally so I came in here hoping there would be some fun Java bashing.
  17. Clearly, English is not your first language, so I'm telling you that grammatically the sentence doesn't make sense. It doesn't make sense because those words do not go together in that way.
  18. The question doesn't even make sense.
  19. I think it might be more accurate to say timestamps default to GMT
  20. Which was my point, you are saying the version that is available for download is ancient. It's not, it's the current version. Just because it doesn't support HTML5 doesn't make it NOT the current version.
×
×
  • 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.