Search results for query: *

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

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

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.

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

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

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

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

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

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

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

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

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