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){ |