Cleanining up 80 column concatenated text
1. Put the whole query on one line, remove the concatenation operators 2. Remove the double spaces that appear a few times in the query 3. Use string-interpolated variable statementPid rather than the ugly concatenation
Start file
$atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f " . " left join users u on f.id=u.facility_id " . " left join billing b on b.provider_id=u.id and b.pid = '".$stmt['pid']."' " . " where service_location=1"); $row = sqlFetchArray($atres);
End file
$atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f left join users u on f.id=u.facility_id left join billing b on b.provider_id=u.id and b.pid = $statementPid where service_location=1"); $row = sqlFetchArray($atres);
View Diff
1,4c1 < $atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f " . < " left join users u on f.id=u.facility_id " . < " left join billing b on b.provider_id=u.id and b.pid = '".$stmt['pid']."' " . < " where service_location=1"); --- > $atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f left join users u on f.id=u.facility_id left join billing b on b.provider_id=u.id and b.pid = $statementPid where service_location=1");
Solutions by @zulolosi:
Unlock 1 remaining solutions by signing in and submitting your own entry