Simplified description of a query

[laanes]

Hello,

Could anyone explain what this query is doing? And why the use of the sprintf function?

$query = sprintf("SELECT B.*, T.option_name, T.option_type, M.value_name FROM %1\$s_options_bot AS B LEFT JOIN %1\$s_options_mid AS M ON B.value_id = M.value_id, %1\$s_options_top AS T WHERE B.option_id = T.option_id AND B.product = %2\$d ORDER BY T.option_name, M.value_name ASC", $glob['dbprefix'], $_GET['productId']);

Kind regards,
laanes

[dagon]

have a look at the sprintf() page in the manual