Line 354... |
Line 354... |
354 |
sensitive). Also, beware of items like select zip,concat(state,', ', city) from zip_codes. It is
|
354 |
sensitive). Also, beware of items like select zip,concat(state,', ', city) from zip_codes. It is
|
355 |
much better to rewrite that as select zip,concat(state,', ', city) mytown from zip_codes.
|
355 |
much better to rewrite that as select zip,concat(state,', ', city) mytown from zip_codes.
|
356 |
|
356 |
|
357 |
If you don't know what all that means, get a book on SQL
|
357 |
If you don't know what all that means, get a book on SQL
|
358 |
*/
|
358 |
*/
|
359 |
function queryToTable ( $sql, $format = '', $makeTableDef = true, $append='' ) {
|
359 |
function queryToTable ( $sql, $format = array(), $makeTableDef = true, $append='' ) {
|
360 |
//print "\n\n$sql\n\n";
|
360 |
//print "\n\n$sql\n\n";
|
361 |
$tdTextDefinition = '<td valign=' . HTML_QUOTE_CHAR . 'top' . HTML_QUOTE_CHAR . '>';
|
361 |
$tdTextDefinition = '<td valign=' . HTML_QUOTE_CHAR . 'top' . HTML_QUOTE_CHAR . '>';
|
362 |
$tdNumberDefinition = '<td valign=' . HTML_QUOTE_CHAR .'top' . HTML_QUOTE_CHAR . 'align=' . HTML_QUOTE_CHAR . 'right' . HTML_QUOTE_CHAR . '>';
|
362 |
$tdNumberDefinition = '<td valign=' . HTML_QUOTE_CHAR .'top' . HTML_QUOTE_CHAR . 'align=' . HTML_QUOTE_CHAR . 'right' . HTML_QUOTE_CHAR . '>';
|
363 |
$rows = array();
|
363 |
$rows = array();
|
364 |
$html = '';
|
364 |
$html = '';
|