Prototype

bool sasql_result_all( resource $result 
[, $html_table_format_string 
[, $html_table_header_format_string 
[, $html_table_row_format_string 
[, $html_table_cell_format_string 
] ] ] ] )

Description

Fetches all results of the $result and generates an HTML output table with an optional formatting string.

Parameters

$result   The result resource returned by the sasql_query function.

$html_table_format_string   A format string that applies to HTML tables. For example, "Border=1; Cellpadding=5". The special value none does not create an HTML table. This is useful if you want to customize your column names or scripts. If you do not want to specify an explicit value for this parameter, use NULL for the parameter value.

$html_table_header_format_string   A format string that applies to column headings for HTML tables. For example, "bgcolor=#FF9533". The special value none does not create an HTML table. This is useful if you want to customize your column names or scripts. If you do not want to specify an explicit value for this parameter, use NULL for the parameter value.

$html_table_row_format_string   A format string that applies to rows within HTML tables. For example, "onclick='alert('this')'". If you would like different formats that alternate, use the special token ><. The left side of the token indicates which format to use on odd rows and the right side of the token is used to format even rows. If you do not place this token in your format string, all rows have the same format. If you do not want to specify an explicit value for this parameter, use NULL for the parameter value.

$html_table_cell_format_string   A format string that applies to cells within HTML table rows. For example, "onclick='alert('this')'". If you do not want to specify an explicit value for this parameter, use NULL for the parameter value.

Returns

TRUE on success or FALSE on failure.

Related functions

• sasql_query