I have for example an objec room which has an atribute floor which is text.
Let's say that $room->floor = "hi i'm a floor"
my querry statement would be"UPDATE room SET floor=$room->floor where id=room->id"
when I insert it with php into a mysql db it gives an error because the '. How can i prevent this?