In moving from COBOL and MVS to procedural PHP and now to Object based PHP I have found my code to be a bit bulky. It has gotten much better and now my module project is now pretty close to something I might not be ashamed to let someone else look at.

Theres a particular piece of code related to a MySQL query I am having problems digesting.

$sql = sprintf('UPDATE %s SET sess_updated = %u, sess_data = %s WHERE sess_id = %s', $this->db->prefix('session'), time(), $this->db->quoteString($sess_data), $sess_id);

Im using this as a example case it was on my desktop at the time.

The Dumb question of the day

What do the %s and %u represent, Where are they set or am I looking at this query from too literal a view.

nothing to do with the query as such. It is a string manipulation function that is used.

sprintf reference in PHP manual

Thank you so so so very much. Thats been bugging me for nearly a year but hasnt been a issue I've wanted to tend to until now.