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 gkittelson 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
Nov 18, 2005
64
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
Don't select ID\Term\Class if has more than 1 record on a day & depends on the last record's rea 1
Replies
2
Views
121
kernal
kernal
kernal
  • Locked
  • Question
Added an end date to a select statement based on the next record's start date 1
Replies
2
Views
66
borisbe
borisbe
youradds
  • Locked
  • Question
Wrong setup for FLOAT? MySQL keeps changing the number!
Replies
6
Views
145
smays
smays
YOUNGCODGER
  • Locked
  • Question
Changing part of text
Replies
1
Views
36
vacunita
vacunita
BadChough
  • Locked
  • Question
Error message on changing MSQL
Replies
1
Views
37
vacunita
vacunita

Part and Inventory Search

Sponsor

Back
Top