www.webdeveloper.com

Search:

Type: Posts; User: MrNobody

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. To cause just a portion of a page to refresh the...

    To cause just a portion of a page to refresh the content of a non-navigable container, i.e., without that container being an IFRAME, would require the use of AJAX. Do you consider the use of AJAX to...
  2. Ultimater, some of those seem close to what I did...

    Ultimater, some of those seem close to what I did before -- but not quite. But I didn't know about array_combine(), so I think I'm going to incorporate that in a slightly different manner than you...
  3. [RESOLVED] alternative to list() function?

    I need an efficient method to extract the elements of an array into the current symbol table, but I can't use either extract() or list() because the variable names I want to create will either be...
  4. With the help of some hints from the MySQL...

    With the help of some hints from the MySQL website, I worked out the following query which does everything I need:

    $query = "Select GROUP_CONCAT(c1.cat_name) AS cat1_name,...
  5. Seems the problem with approach number 1 is that,...

    Seems the problem with approach number 1 is that, as stated, the primary order of the returned list also needs to be based on the three levels of category names -- and -- I need to be able to page...
  6. It is surprising nobody knows how to handle this....

    It is surprising nobody knows how to handle this. I even posted this question at the MySQL website and got no answer there, either. :confused:
  7. Replies
    3
    Views
    951

    No response?

    No response?
  8. Replies
    20
    Views
    2,312

    If it wasn't for the fact that you're wanting to...

    If it wasn't for the fact that you're wanting to add 1 to the existing column value, you would be correct. You could always test it, though.
  9. The above is fine if all items have all three...

    The above is fine if all items have all three categories assigned -- but they don't. Thus, those items are being omitted from the list. I need a solution which will also list items which don't have...
  10. Replies
    3
    Views
    951

    It is based upon the POST argument passed to the...

    It is based upon the POST argument passed to the PHP script. The argument is an array of three elements. The PHP script won't be called (AJAX) if the first element is zero (no 1st-level category id...
  11. Replies
    20
    Views
    2,312

    No, not really. In SQL, you need two separate...

    No, not really. In SQL, you need two separate queries for the two different types of operations -- Insert vs. Update. But you don't have to search for the row first. You can try to Update and, if...
  12. Replies
    3
    Views
    951

    [RESOLVED] Seemingly Complex MySQL Query

    I have the following MySQL 5.0.45 tables:

    .----------. .---------. .--------.
    |Categories| |Items | |ItemCats|
    |----------| |---------| |--------|
    |cat_id | ...
  13. Replies
    1
    Views
    628

    You cannot have a query which automatically...

    You cannot have a query which automatically produces that kind of a result set. What you'll have to do is use a regular, ordered query and then build that kind of an output as you spin through the...
  14. Tested out great. Thanks. Yes, I did "come up...

    Tested out great. Thanks.

    Yes, I did "come up with" the rest on my own -- with a bit of hard work and study (that is why it is done in pieces with the reCheck() function thrown in there:D). I...
  15. Hmmm, that is strange... I copied the demo page...

    Hmmm, that is strange... I copied the demo page (as posted above) and tested it (again) in IE7. The ones I said work -- work fine. The ones I said don't work -- don't work. However, then I loaded...
  16. It seems this is one [close] solution: SELECT...

    It seems this is one [close] solution:

    SELECT c1.cat_name as cat1_name, c2.cat_name as cat2_name, c3.cat_name as cat3_name, item_code, item_name
    FROM Items
    Join ItemCats as ic1 On item_id =...
  17. Replies
    2
    Views
    757

    Perhaps you mean this? ...to set those three...

    Perhaps you mean this? ...to set those three fields to zero-length string values?

    SQL = "UPDATE Table SET Field1 = '', Field2 = '', Field3 = '' WHERE id = " & id & ";"
    Use double quotes to...
  18. [RESOLVED] Get Category Names from Lookup Table

    This should be simple for any MySQL guru. I need to create a query of an items table which includes the names, in the same row as the item, for the 3-level categories associated with each item in...
  19. Sorry, but SQL is really designed for normalized...

    Sorry, but SQL is really designed for normalized data.
  20. These all work fine: http://www.domain.name...

    These all work fine:

    http://www.domain.name
    http://www.domain.name/a.dir/b.dir/c.dir/
    http://www.domain.name/a.dir/b.dir/c.dir/file.ext
    http://www.domain.name/a.dir/b.dir/c.dir/file.name.ext...
  21. host does not stop capturing at the last period...

    host does not stop capturing at the last period in the host name -- at least, not as I supplied the page. host captures until either a colon, a slash, a question mark, or a hash mark is encountered....
  22. Well, turns out I spoke too soon, again! Funny...

    Well, turns out I spoke too soon, again! Funny how you change one thing and another things breaks. Further testing reveals that if the URI contains only a file name (no file extension), the entire...
  23. OK, I thought perhaps that is what was happening,...

    OK, I thought perhaps that is what was happening, I just had no hint from the documentation that this is what would happen. :D Thanks.
  24. Well, I asked too soon. I solved the second...

    Well, I asked too soon. I solved the second issue -- so the first issue is moot. However, if someone can explain to me why the first issue could be observed in the first place, I'd certainly...
  25. [RESOLVED] Parsing URI With Regular Expression

    Basically, I believe I've succeeded. However, there is one small detail which I'd like to lick. Now, first of all, note that I'm using a little debugging function (reCheck) in this page so that I...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4
HTML5 Development Center



Recent Articles