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 Rhinorhino 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?

    ...explain the last post for me. So I query by date desc, then spit into an array. I loop through the array outputting each post in order...but *somehow* I need to search every post for other posts that have that postID in their inreplyTo field. I'm not sure how to go about that at all. If...
  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?

    ...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 query I could just join that table with the...
  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?

    ...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 now due to how busy I am)...
  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)

    ...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 tags and another has 10, then your divisor is 10,000...
  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.

    ...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 could access all <span> tags like this: var aSpans =...

Part and Inventory Search

Back
Top