Jump to content

Maq

Administrators
  • Posts

    9,363
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by Maq

  1. You could rewrite it like this (there are certain rules for interpolating strings). $sql = "UPDATE member SET paydate='CURDATE()', status='regular', payamount=payamount+$amount, validitydate='$validitydate' WHERE id={$_SESSION['userid']};
  2. Use this then: SELECT name FROM iqtable ORDER BY id LIMIT 5
  3. Works fine for me. Post more of the surrounding code. Where do $total and $mitax come from?
  4. First 5 records according to what? (id, date, etc...) It would look something like: SELECT * FROM table LIMIT 5 (You will need ORDER BY if you want to get the first/last 5 according to a specific column)
  5. He's just helping you...
  6. Try: AND date > DATE_SUB(NOW(), INTERVAL '1' WEEK) Have you echoed out your query to see what's actually being passed? Have you checked to see if your query died? $result = mysql_query($sql) or die(mysql_error());
  7. Yes, you definitely need to. It's illogical that 'category' could equal 5 different exact values at the same time.
  8. Try something like this: SELECT * FROM table WHERE date > DATE_SUB(NOW(), INTERVAL '1' MINUTE);
  9. Did you actually resolve this issue? I see you marked it solved, but sounds otherwise.
  10. Maq

    ADvice

    IMO, I wouldn't even start to think about advertising unless you receiving a lot of traffic first.
  11. Couple concerns: - There is no max character check. If you enter over a certain amount of characters it disappears into the right panel. - Should have the ability to hit to post your message. (works now) - What does "Get Message" do? (explained in chat )
  12. http://www.codetoad.com/javascript/isnumeric.asp You should also check server-side, what language are you using? If PHP, you can use isNumeric, or better yet just check it with regex (\d+).
  13. Is this an actual file, or an entry in a database?
  14. You can get stand-a-lone IEs, they aren't very stable, at least when I used them, but they are accurate. Axeia, I think you were referring to this product: http://www.istartedsomething.com/20090318/expression-web-superpreview-cross-browser-testing/ and this post: http://www.phpfreaks.com/forums/index.php/topic,243716.0.html
  15. Switch your single and double quotes around, your variable isn't being interpolated. $sql="SELECT id FROM member_messages WHERE user_id = '$krazycool' and status ='NEW'";
  16. Yes, put this at the top of your script, before the include file but after the opening '<?php' tag. ini_set ("display_errors", "1"); error_reporting(E_ALL);
  17. Are you talking about Blizzard or Google? I assume Blizzard since you mentioned games. If so, does Blizzard offer similar benefits?
  18. What do you mean, "list all its users and passwords"? If you want to pay someone, I can move this thread to the freelance section for more replies.
  19. Haha, some of those are hilarious, just what I needed during work.
  20. Try: SELECT i, COUNT(*) as num FROM table GROUP BY i HAVING num > 1
  21. Sure, can you post what values you want to check and your table structure?
  22. For future reference surround your code with tags. There is also a "topic solved" tab in the bottom left.
  23. I don't even see where those 2 methods are defined.
  24. http://www.google.com/intl/en/jobs/lifeatgoogle/benefits.html#ta If anyone has ever worked or visited Google, I would like to hear first hand about their experience working/visiting there.
  25. Yes it is possible. There are multiple techniques depending on what exactly you're trying to do. Please provide a little more detail. This has nothing to do with regular expressions, moving to php help.
×
×
  • 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.