Search:

Type: Posts; User: eyeRmonkey

Page 1 of 13 1 2 3 4

Search: Search took 0.25 seconds.

  1. Replies
    416
    Views
    131,189

    Re: Contest 6 - Sudoku solver - Discussion

    This is a ridiculous post bump, but I just wanted to say (6.5 years later!) that I think about this contest often. It was a fun problem to solve right when I started getting into programming. And now...
  2. Replies
    21
    Views
    1,230

    Re: Facebook pokes and pop-ups

    @dclamp: Just to let you know, ts <3s me too much to block me. ;)
  3. Replies
    21
    Views
    1,230

    Re: Facebook pokes and pop-ups

    To be fair, it's more likely that MySpace (even with billions of dollars) just can't seem to hire good programers and write a proper website. I'm sure ASP.NET is decent (although I've never tried...
  4. Replies
    21
    Views
    1,230

    Re: Facebook pokes and pop-ups

    Let's just put it this way:

    Facebook = Linux+PHP
    MySpace = Windows+ASP.NET

    You decide which runs better ;)
  5. Replies
    21
    Views
    1,230

    Re: Facebook pokes and pop-ups

    jQuery is what I would recommend. Read some tutorials on jQuery and on AJAX in general. When you have a specific question, we can help you with that, but we can't write the code for you.

    As far as...
  6. Replies
    21
    Views
    1,230

    Re: Facebook pokes and pop-ups

    I know those poke dialog very VERY well. I wrote this:

    https://addons.mozilla.org/en-US/firefox/addon/3910

    Yes. They do use PHP. And yes. They do use mock ajax.

    Here is a good starting place...
  7. Replies
    14
    Views
    1,242

    Re: Locking a row from being READ

    I'll be honest, I didn't understand your reply that well.

    I gave in and figured out how to do multi-queries in PHP and came up with this:

    DROP TABLE IF EXISTS artists_temp;
    CREATE TEMPORARY...
  8. Replies
    14
    Views
    1,242

    Re: Locking a row from being READ

    The primary keys aren't in any sort of order, but I don't see that being important. The primary keys are also strings, not numbers.

    The numbers are more random than that. Sometimes I'll need 100,...
  9. Replies
    14
    Views
    1,242

    Re: Locking a row from being READ

    I do have temp tables available to me. It just seems like a hassle to me, but I suppose it's worth it.

    Could you show me what your procedure would look like? I can translate it to MySQL...
  10. Replies
    14
    Views
    1,242

    Re: [RESOLVED] Locking a row from being READ

    Alright. I realized I have another problem. If I need to do this multiple rows, the idea breaks down. Example:

    SELECT * FROM artists WHERE status='todo' LIMIT 100;
    UPDATE artists SET...
  11. Replies
    14
    Views
    1,242

    Re: Locking a row from being READ

    Simplicity was the key!

    That's it.

    Here's what I was thinking before you mentioned checking the affected rows: In the "undesirable scenario" I wouldn't have checked the number of rows affected...
  12. Replies
    14
    Views
    1,242

    Re: Locking a row from being READ

    The 60 seconds of processing does happen AFTER I update the row and mark it as "in processing".

    The scenario you mentioned would, of course, be what I WANT to happen, but since these scripts are...
  13. Replies
    14
    Views
    1,242

    Re: Locking a row from being READ

    Thanks for your reply szlamany! I was hoping you would be able to provide some input on this.

    What you said is true, but I forgot to mention one thing. After the update occurs, I do 60 seconds...
  14. Re: [RESOLVED] Difficult nested SELECT within an INSERT statement

    Later on when I use this data, I need to be able a unique identifier based on the name. Therefore, if there are three people with the name 'Joe' in the database, I need to able to make a unique...
  15. Replies
    14
    Views
    1,242

    [RESOLVED] Locking a row from being READ

    I need to temporarily lock a row from being read by any other queries. I need to do this because I need to get the next row marked as "TODO", then change it to "IN PROCESSING". I don't want one of...
  16. Re: Difficult nested SELECT within an INSERT statement

    I guess I didn't mention that, but the first Joe will never be deleted.
  17. Re: Difficult nested SELECT within an INSERT statement

    Dang. Alright. I guess I'll just do some checking before I execute the query to ensure that no artist name appears twice.

    I'm going to leave this unresolved for a day or so to see if anyone else...
  18. Re: Difficult nested SELECT within an INSERT statement

    Here is what I came up with to do the muti-row insert:



    INSERT IGNORE INTO artists (primary_key, name, name_based_id)
    Select '10:w9ftxqe5ldhe' as primary_key, 'Joe' As name, (SELECT COUNT(*)...
  19. Re: Difficult nested SELECT within an INSERT statement

    Doing this query:



    INSERT INTO artists (primary_key, name, name_based_id)
    Select * From
    (Select '10:w9ftxqe5ldhe' as primary_key, 'Joe' As name, (SELECT COUNT(*) FROM artists WHERE...
  20. Re: Difficult nested SELECT within an INSERT statement

    I still get errors about the square brackets on both of those.
  21. Re: Difficult nested SELECT within an INSERT statement

    I can't get it to stop having syntax errors. The first error I get is:

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right...
  22. [RESOLVED] Difficult nested SELECT within an INSERT statement

    From everything I've read, I don't think this is possible, but here is the statement I am trying to achieve:

    My columns: primary_key, name, name_based_id


    INSERT IGNORE INTO artists...
  23. Thread: Call api?

    by eyeRmonkey
    Replies
    8
    Views
    666

    Re: Call api?

    /me takes this moment to congratulate Penagate on his 10,000th post.

    ... You may now resume your conversation.
  24. Re: Need regular expression that matches any date acceptable by strtotime()

    Because I need to use preg_match_all() on a paragraph of text that could contain any type of date.
  25. Re: Need regular expression that matches any date acceptable by strtotime()

    Hmmm. I might have found part of the answer:

    http://regexlib.com/REDetails.aspx?regexp_id=113

    That doesn't match DD mmm YYYY or DD mmmmmm YYYY, though.
  26. Need regular expression that matches any date acceptable by strtotime()

    Hey all.

    I was wondering if anyone knew of where I could find a regular expression that would match any date that is acceptable by strtotime().

    Here is what I have so far (not complete by any...
  27. Replies
    3,454
    Views
    623,511

    Re: What song are you listening to right now?

    Say What You're Gonna Say - This Is Me Smiling

    (This Is Me Smiling is an AWESOME band. You guys should check them out.)
  28. Replies
    6
    Views
    861

    Poll: Re: Composite Primary Keys

    I voted for the one where you spelled something wrong. :)
  29. Replies
    16
    Views
    792

    Re: I've been bought!

    I paid too much. $44 for 3 months hosting and the domain name. I could've gotten 12 months at godaddy.com. I think I'll switch once my 3 months are over.
  30. Replies
    16
    Views
    792

    Re: I've been bought!

    Yeah. Paid for the domain and hosting. I went through brinkster.com, but I think I should've used godaddy.com because they are way cheaper.
  31. Replies
    16
    Views
    792

    Re: I've been bought!

    thx?

    Haha. :)
  32. Replies
    16
    Views
    792

    I've been bought!

    http://eyermonkey.com/

    TA-DA! I was getting jealous of Penagate, so I bought my own perpetually-under-construction domain name.

    http://penagate.com/ ... See any resemblance? Haha. He helped me...
  33. Replies
    6
    Views
    944

    Re: Breaking an Encryption

    Meh. This is sounding as hopeless as I originally thought. Sad times. I guess I'll just give up and stick to one of the many possible hash identifiers instead of a static one.
  34. Replies
    6
    Views
    944

    Re: Breaking an Encryption

    It definitely isn't based on cookies, because the links can be bookmarked and work for everyone.

    It is possible that it's based on some meaningless data.

    But, if it were based on just the ID,...
  35. Replies
    6
    Views
    944

    Breaking an Encryption

    I'm writing a program that interfaces with http://www.allmusic.com.

    I am trying to find a way to break the encryption on their SQLIDs. Here is a typical URL to an album on their site:
    ...
  36. [PHP] Preg_relpace ampersand ( & ) with &

    With the help of the wonderful Penagate, I was able to solve a problem I had when dealing with improper ampersands on certain websites.

    The problem was that some sites doesn't escape their...
  37. Replies
    11
    Views
    1,108

    Re: Test Gmail Spam Filter

    Update on op.gpsam@gmail.com if anyone cares:

    You are currently using 2063 MB (74%) of your 2797 MB

    130,593 total messages.
  38. Replies
    3,454
    Views
    623,511

    Re: What song are you listening to right now?

    My printer.
  39. Replies
    320
    Views
    8,906

    Re: Three Word Story

    internet tubes. He
  40. Replies
    30
    Views
    1,071

    Re: 11 word story

    The cat then clawed out valleysboy1978's eyes because his fit anyway.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width