ah ok so it should be like this then?

Code:
"SELECT VID FROM video WHERE type = 'public' AND approve = '1' AND active= '1'"
Cos that's what I poked in there and so far it didn't seem to hurt anything.