| 25,22 → 25,22 |
|---|
| } |
| |
| $operators=array( '=','<', '>', '<=', '>=', 'regexp', 'like' ); |
| if ($config[sql_type] == 'pg'){ |
| if ($config['sql_type'] == 'pg'){ |
| $operators=array( '=','<', '>', '<=', '>=', '~', 'like', '~*', '~~*', '<<=' ); |
| } |
| |
| $link = @da_sql_pconnect ($config) or die('cannot connect to sql databse'); |
| $fields = @da_sql_list_fields($config[sql_accounting_table],$link,$config); |
| $no_fields = @da_sql_num_fields($fields,$config); |
| $link = da_sql_pconnect ($config) or die('cannot connect to sql databse'); |
| $fields = da_sql_list_fields($config[sql_accounting_table],$link,$config); |
| $no_fields = da_sql_num_fields($fields,$config); |
| |
| unset($items); |
| |
| for($i=0;$i<$no_fields;$i++){ |
| $key = strtolower(@da_sql_field_name($fields,$i,$config)); |
| $val = $sql_attrs[$key][desc]; |
| $key = strtolower(da_sql_field_name($fields,$i,$config)); |
| $val = $sql_attrs[$key]['desc']; |
| if ($val == '') |
| continue; |
| $show = $sql_attrs[$key][show]; |
| $show = $sql_attrs[$key]['show']; |
| $selected[$key] = ($show == 'yes') ? 'selected' : ''; |
| $items[$key] = "$val"; |
| } |
| 263,9 → 263,9 |
|---|
| } |
| echo "</tr>\n"; |
| |
| $search = @da_sql_query($link,$config,$query); |
| $search = da_sql_query($link,$config,$query); |
| if ($search){ |
| while( $row = @da_sql_fetch_array($search,$config) ){ |
| while( $row = da_sql_fetch_array($search,$config) ){ |
| $num++; |
| echo "<tr align=center>\n"; |
| foreach($accounting_show_attrs as $val){ |