KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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'); }
Tags (comma-separated)
Save Edits
Cancel