Ryan Ashbrook
Sun 27th Jul '08, 8:36am
http://www.vbulletin.com/docs/html/codestandards_sql_query
$db->query_read("SELECT COUNT(*) AS records, SUM(field_one) AS total FROM " . TABLE_PREFIX . "table");If a query string is long and would be better written on more than one line, separate it onto separate lines, putting the clause keyword at the start of the line in the following manner: double-quote, newline, indent, [query string], newline, outdent, double-quote.
Shouldn't $db->query_read("SELECT COUNT(*) AS records, SUM(field_one) AS total FROM " . TABLE_PREFIX . "table"); be wrapped in a code block? :)
$db->query_read("SELECT COUNT(*) AS records, SUM(field_one) AS total FROM " . TABLE_PREFIX . "table");If a query string is long and would be better written on more than one line, separate it onto separate lines, putting the clause keyword at the start of the line in the following manner: double-quote, newline, indent, [query string], newline, outdent, double-quote.
Shouldn't $db->query_read("SELECT COUNT(*) AS records, SUM(field_one) AS total FROM " . TABLE_PREFIX . "table"); be wrapped in a code block? :)