How can I update the displayed values on my page when MySQL records change?

Date: 28-07-2023

I am trying to create a very simple auction page and I am getting closer and closer thanks to this community.

The page is very simple, what happens is that someone can put their name and a bid, place the bid, then the page will refresh for them with the new bid (providing it is higher than the current). Unfortunately, this only refreshes the page for whoever placed the bid.

I would like the page to update for everyone currently looking at it, so they can make sure to bid higher than the current bid.