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 @federicogalassi:
Unlock 5 remaining solutions by signing in and submitting your own entry