Doing the ol' switch around with the modem between the computer and PS3 are you? That may have a part to play in it.
Try powering down the modem for a couple of minutes when you switch the cable and then plug it back in. You may also want to make sure the username and password didn't get changed on your ISP log on in the PS3's settings if they are in there.