When you have a long fields in SQL query, how do you make it more readable?
For example:
public function findSomethingByFieldNameId($Id) {
$sql = "SELECT field1, field2, field3 as Field3_Something, field4, field5, field6, field7, field8, field9
FROM table
JOIN table2 AS TNS ON TNS.id = table.id
WHERE something = 1";
return $this->db->fetchData($sql, null, 'all');
}
<?php
public function findSomethingByFieldNameId($Id) {
$sql = "SELECT
field1,
field2,
field3 as Field3_Something,
field4,
field5,
field6,
field7,
field8,
field9
FROM
table
JOIN table2 AS TNS
ON TNS.id = table.id
WHERE
something = 1";
return $this->db->fetchData($sql, null, 'all');
}
?>