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!
-
Congratulations Shaun E 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: *
- Users: mksolutions
- Content: Threads
- Order by date
-
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...- mksolutions
- Thread
- Replies: 2
- Forum: MySQL
-
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...- mksolutions
- Thread
- Replies: 10
- Forum: PHP
-
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...- mksolutions
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
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...- mksolutions
- Thread
- Replies: 3
- Forum: Microsoft: Windows
