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. mksolutions

    MySQL Distinct question

    Thanks for the reply. I understand what is going on now. Now I just do not understand how to fix it. :) I think the entire search page needs rewritten as queries are taking too long. I think I have too many embedded queries. I have given up trying to fix this myself...and have started...
  2. mksolutions

    MySQL Distinct question

    Here is a sample query I am working with: SELECT DISTINCT Roster.RosterID AS RosterID FROM Roster INNER JOIN Photos ON Roster.RosterID = Photos.RosterID INNER JOIN Users ON Photos.UserID = Users.UserID INNER JOIN Roads ON Roads.RoadID = Roster.RoadID ORDER BY Photos.PhotoID DESC LIMIT 200. The...
  3. mksolutions

    Once per session

    I guess I do not understand how you would distinguish between the photos. Yes, IP 1.1.1.1 has visited, but you have no way to know which photos they have viewed unless you also record those. I am showing EACH photo viewed, not just each time they visit.
  4. mksolutions

    Once per session

    What about just recording the hit by the current IP just once per day/hour? If the people don't see the count go up with each refresh they'll stop trying that." Do you mean saving that data in the database? I could easily make it save the IP and photo in the database, then having those...
  5. mksolutions

    Once per session

    I just tried setting up so the photo viewed is stored in a session variable. It seems to be working fine, allowing a user to only add one view per session. I am still curious now many session variables I can set. Will a user max these out if they visit 1000 photos??? Thanks! Matthew
  6. mksolutions

    Once per session

    Is is possible to store that much in session variables? Since it is on the server, space shouldnt be a concern. What is the limit on session variables? Matthew
  7. mksolutions

    Once per session

    I just checked... "Browsers are required to retain no more than 20 cookies for a single domain" There goes that idea. Is the only way to accomplish this to create a new table and track what user views what photo? That is a lot of database activity for not much use. Matthew
  8. mksolutions

    Once per session

    Isnt there a limit on how many variables can be set in a cookie? What if the user views all 9000 photos? I like the idea of the cookie keeping track, then after say a few days the cookie will be gone. I am just not sure about how much data can be stored in a cookie. Thanks for the response...
  9. mksolutions

    Once per session

    I run a photo site written in PHP with a MSSQL backend. Everytime a photo is displayed, I add one to a "viewed" field, showing how many times that photo has been viewed. It appears someone has figured out that all they need to do to bump the count is keep hitting refresh. Is there a way to...
  10. mksolutions

    Access Duplicate Query Wizard

    I am running Access 2003, and have it set up to look at a SQL database. I see articles all the time showing how to use a wizard to find duplicate data. I can not find that option in my Access. I have installed all the options, etc. Is it because I am using a project instead of an access...
  11. mksolutions

    Remotely update computers

    I had no idea that a CD was available for just such a thing. That is exactly what I was looking for. As for drivers, I bring along the most common ones. I havent run into too many driver problems. Thanks for that great piece of information! MAtthew
  12. mksolutions

    Remotely update computers

    I repair a lot of personal and business computers, most being on dial-up connections. It is next to impossible to do windows updates on that connection, as most dont even connect above 30k (Yes, this is a rural area). I end of dragging most computers home with me to do the updates on my T1...

Part and Inventory Search

Back
Top