Ideally stored procedures would be my choice since I like to keep DB related things within the DB. With PHP and MySQL however, I'm still somewhat behind the times because I just don't use stored procedures with that combo. I'd also argue against 'direct queries' being more "simple, faster and portable" than stored procedures (in general terms). I'm not quite sure how xenon thinks otherwise, maybe he can tell us.