Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alphacooler

    Indented Comments?

    BACK from the dead (AGAIN!). After starting this thread I tried to get this to work with jpadie's method, but I couldn't quite get it. Well I have a new project I would like to definitely use this on. So perhaps Jpadie or somebody else could explain the last post for me. So I query by date...
  2. alphacooler

    Forum Thread Order by Post Date...Am I DOOMED?

    NM, that worked! Oh goodness, thankyou so much r937. I will now worship you as my MySQL Idol.
  3. alphacooler

    Forum Thread Order by Post Date...Am I DOOMED?

    append CREATE [TEMPORARY] TABLE mytablename select threadid , MIN(messages.date_added) as min_date , MAX(messages.date_added) as last_message , COUNT(*) as num_messages from messages group by threadID Like that? Then in another...
  4. alphacooler

    Forum Thread Order by Post Date...Am I DOOMED?

    r937, Could you perhaps give me an example of storing that into a table. Would that be a temporary table, or would it forever exist? (Obviously I've never done this before). Thanks so much r937, I owe you so much.
  5. alphacooler

    Forum Thread Order by Post Date...Am I DOOMED?

    Thanks for the reply, I forgot to mention that I am on MySQL 3.23, so I can't utilize subqueries. I take it there is no other way to do this? Also, I could easily upgrade to MySQL 4.1+, but is there *any* chance that doing so would break some of my current queries? (I can't afford that right...
  6. alphacooler

    Forum Thread Order by Post Date...Am I DOOMED?

    I think I shot myself in the foot by not normalizing my forum schema. Here is what my table for forum posts looks like: messageID (unique, auto increment) threadID groupID (index) userID subject body date_added first_post (yes or no) So for a specific Group/Forum page, I am trying to get a...
  7. alphacooler

    Indented Comments?

    So to output a particular thread, I would need to do one giant query ordered by date, then run a query for every single post checking if there are any posts with the same ID in the reply field? Is there another way? Isn't embedding a select inside a loop a bit dirty?
  8. alphacooler

    Count Matches in Array (with duplicates)

    I see your point. Tags are used to describe a wide array of user submitted articles. Over time a user's tagset will start to fill with tags as they view more articles. Duplication of certain tags (after normalizing for tags that are more likely than others) means that a user is more interested...
  9. alphacooler

    Count Matches in Array (with duplicates)

    None. The only differentiating factor is the frequency of a tag within a user's set.
  10. alphacooler

    Count Matches in Array (with duplicates)

    Yes, I see exactly what you mean vacunita, but my statement in post #3 is incorrect because of what I mentioned in my last post. Over time all users will asymptotically approach 100% matches due to the nature of "tagging" for categorization. I apologize for not telling you to disregard that...
  11. alphacooler

    Count Matches in Array (with duplicates)

    My last post was referring to jpadie, vacunita, your last post would neglect multiple tag matches, which are going to be key in detecting patterns of what people like. But I think the biggest problem with that approach is that for any given subject there is going to be a finite set of possible...
  12. alphacooler

    Count Matches in Array (with duplicates)

    I originally had the same function and resulting array, but I run into a problem of placing meaning to this. If I sum up the matches, then divide by the total possible matches to normalize (count(array1)*count(array2)) I have a hard time with interpretation. For instance if one array has 1000...
  13. alphacooler

    Count Matches in Array (with duplicates)

    I didn't say what the output array should look like because I am not sure. The problem with your suggested output array is that if I try to sum it and then normalize by the total possible matches I end up with less than a 50% match between the two arrays. But array2 has 100% of its tags...
  14. alphacooler

    Count Matches in Array (with duplicates)

    I have two arrays like the following: $array1 = array("red", "red", "blue", "green", "blue"); $array2 = array("blue", "blue", "red", "red"); I want to count all of the matches between the two arrays; however, (counting) array_intersect does not work because each array has duplicates (which I...
  15. alphacooler

    JS Screen Caps

    Would it be conceivable to create a script to do a screen capture of a page?
  16. alphacooler

    fopen() to download file?

    I just tried this: "<?php exec("/usr/bin/wget http://fly.srk.fer.hr/jpg/flyweb.jpg"); ?>" should work, but doesn't.
  17. alphacooler

    fopen() to download file?

    Okay, so I was completely wrong, I need to figure out how to use WGET to download files. Any pointers? I'm clueless.
  18. alphacooler

    fopen() to download file?

    I would like to be able to download a flash video file that I have uploaded to a site (i.e. youtube, google video). I parse the page and can create the actual file url (i.e.: http://youtube.com/player2.swf?video_id=phxIJoW330Y&l=165&t=OEgsToPDskIJNrC6JwNoaCzpBXyYqPZe) However, I am uncertain as...
  19. alphacooler

    Urlencode() + or %20?

    Which is correct to have in URL's? +'s or %20 for spaces? I thought %20 was the correct way, but urlencode is giving me +'s instead. Thanks.
  20. alphacooler

    document.getElementByTagName HELP.

    I have a list (<ul></ul>) that has some <span> tags in it. I would like to use DHTML to dynamically style this list based on different user selections through a form. On an onBlur of a field I want to change the color of *all spans* contained in <ul></ul>. Say <ul> has id="my_list" so I...

Part and Inventory Search

Back
Top