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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing record's status

Status
Not open for further replies.
VAMick

VAMick

Programmer
Joined
Nov 18, 2005
Messages
64
Location
US
I'd like for a record's status to change automatically from unread to read if a page loads with the record on it. How could this be done?

php/mysql pages.

thanks.
 
Sort by date Sort by votes
After the script that produces the page fetches the record, that script can change the status of the record. All it will require is an UPDATE query.

Want the best answers? Ask the best questions!

TANSTAAFL!!
 
Upvote 0 Downvote
What if there were multiple new records?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kernal
  • Locked
  • Question Question
Don't select ID\Term\Class if has more than 1 record on a day & depends on the last record's rea
Replies
2
Views
309
kernal
kernal
kernal
  • Locked
  • Question Question
Added an end date to a select statement based on the next record's start date
Replies
2
Views
224
borisbe
borisbe
youradds
  • Locked
  • Question Question
Wrong setup for FLOAT? MySQL keeps changing the number!
Replies
6
Views
420
smays
smays
YOUNGCODGER
  • Locked
  • Question Question
Changing part of text
Replies
1
Views
106
vacunita
vacunita
BadChough
  • Locked
  • Question Question
Error message on changing MSQL
Replies
1
Views
74
vacunita
vacunita

Part and Inventory Search

Sponsor

Back
Top