Сообщений в теме: 6

[serg777]

// Получаем сумму содержимого полей "Сумма" таблицы "Позиции счета", где поле "Счет" равно номеру счета.

$sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1
WHERE status=0 AND f1='".$line['Контактные данные']['ID']."'";

$res = mysql_query($sqlQuery);
$row = mysql_fetch_array($res);
$line['Контактные данные']['Баланс'] = $row['summa'];

Вроде бы всё правильно сделал, но выдает ошибку...
Может быть, сейчас уже какой-то другой механизм этого вычисления?


Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/3aka3/public_html/include/functions1.php(264) : eval()'d code on line 7 get_table: invalid table_id:
#0 get_table() called at [/home/3aka3/public_html/include/functions1.php:204] #1 form_event_recurs(Array ([id] => 21,[cat_id] => 1,[table_num] => 1,[name_table] => Контактные данные,[full_name] => ,[add_text] => ,[edit_text] => Контактные данные,[def_sort] => ,[help] => ,[subtable] => 0,[crypt] => 0,[view_sql] => ,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[auto_save] => 1,[LOP] => 100,[fix_search_submit] => 0,[user_table_link] => a:8:{s:5:"login";s:3:"231";s:8:"password";s:3:"241";s:3:"fio";s:3:"251";s:6:"e_mail";s:3:"281";s:5:"phone";s:3:"291";s:8:"group_id";s:3:"301";s:7:"user_id";s:3:"311";s:6:"invite";s:1:"2";},[display] => Array ([name_table] => Контактные данные,[full_name] => ,[add_text] => ,[edit_text] => Контактные данные,[def_sort] => ,[help] => ),[user_table_fields] => Array ([login] => 231,[password] => 241,[fio] => 251,[e_mail] => 281,[phone] => 291,[group_id] => 301,[user_id] => 311,[invite] => 2),[vis] => 1,[add] => 0,[del] => 0,[arc] => 0,[imp] => 0,[exp] => 0,[adf] => 0,[bed] => 0,[ext] => 0,[view_tb] => 1,[view] => 1,[view_lnk] => 1,[int_names] => Array ([f311] => 311,[id] => 191,[user_id] => 201,[add_time] => 211,[status] => 221,[f231] => 231,[f241] => 241,[f251] => 251,[f281] => 281,[f291] => 291,[f361] => 361,[f301] => 301,[f1241] => 1241,[f1281] => 1281),[link_tables] => Array (),[table_fields] => Array ([311] => Array ([id] => 311,[table_id] => 21,[field_num] => 1,[name_field] => Пользователь,[type_field] => 7,[type_name] => пользователь,[type_value] => 0|0,[default_value] => 0,[type_value_js] => 0|0,[default_value_js] => 0,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 0,[int_name] => f311,[fix_search_on] => 0,[scw_set] => Array (),[groupe] => 0,[use_rights] => 0,[display_groups] => ,[read] => 1,[write] => 1,[rights_ex] => Array ()),[191] => Array ([id] => 191,[table_id] => 21,[field_num] => 2,[name_field] => ID,[type_field] => 10,[type_name] => число,[type_value] => ,[default_value] => {autonumber},[type_value_js] => ,[default_value_js] => {autonumber},[javascript] => ,[help] => ,[main] => 1,[unique] => 1,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 1,[int_name] => id,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array ()),[201] => Array ([id] => 201,[table_id] => 21,[field_num] => 3,[name_field] => Кто добавил,[type_field] => 11,[type_name] => пользователь,[type_value] => 0|0,[default_value] => {current},[type_value_js] => 0|0,[default_value_js] => {current},[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 2,[int_name] => user_id,[fix_search_on] => 0,[scw_set] => Array (),[groupe] => 0,[use_rights] => 0,[display_groups] => ,[read] => 1,[write] => 1,[rights_ex] => Array ()),[211] => Array ([id] => 211,[table_id] => 21,[field_num] => 4,[name_field] => Время добавления,[type_field] => 12,[type_name] => дата/время,[type_value] => 1,[default_value] => {cur.time},[type_value_js] => 1,[default_value_js] => {cur.time},[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 3,[int_name] => add_time,[fix_search_on] => 0,[scw_set] => Array (),[display_time] => 1,[read] => 1,[write] => 1,[rights_ex] => Array ()),[221] => Array ([id] => 221,[table_id] => 21,[field_num] => 5,[name_field] => Статус записи,[type_field] => 13,[type_name] => список,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 4,[int_name] => status,[fix_search_on] => 0,[scw_set] => Array (),[list_values] => Array ([0] => ),[read] => 1,[write] => 1,[rights_ex] => Array ()),[231] => Array ([id] => 231,[table_id] => 21,[field_num] => 6,[name_field] => Логин,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 5,[int_name] => f231,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[241] => Array ([id] => 241,[table_id] => 21,[field_num] => 7,[name_field] => Пароль,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 6,[int_name] => f241,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[251] => Array ([id] => 251,[table_id] => 21,[field_num] => 8,[name_field] => ФИО,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 7,[int_name] => f251,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => 1,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[281] => Array ([id] => 281,[table_id] => 21,[field_num] => 9,[name_field] => E-mail,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 1,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 8,[int_name] => f281,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => 1,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[291] => Array ([id] => 291,[table_id] => 21,[field_num] => 10,[name_field] => Телефон,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 9,[int_name] => f291,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => 1,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[361] => Array ([id] => 361,[table_id] => 21,[field_num] => 11,[name_field] => Адрес доставки,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 1,[fast_edit] => 0,[pp] => 10,[int_name] => f361,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[301] => Array ([id] => 301,[table_id] => 21,[field_num] => 12,[name_field] => Группа,[type_field] => 14,[type_name] => группа,[type_value] => 0|0|777,[default_value] => 777,[type_value_js] => 0|0|777,[default_value_js] => 777,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 11,[int_name] => f301,[fix_search_on] => 0,[scw_set] => Array (),[groupe] => 0,[use_rights] => 0,[display_groups] => 777,[read] => 1,[write] => 1,[rights_ex] => Array ()),[1241] => Array ([id] => 1241,[table_id] => 21,[field_num] => 13,[name_field] => Паспортные данные,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 1,[fast_edit] => 0,[pp] => 12,[int_name] => f1241,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[1281] => Array ([id] => 1281,[table_id] => 21,[field_num] => 14,[name_field] => Баланс,[type_field] => 1,[type_name] => число,[type_value] => 10/0,[default_value] => 0,[type_value_js] => 10/0,[default_value_js] => 0,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 13,[int_name] => f1281,[fix_search_on] => 0,[scw_set] => Array (),[all_dig] => 10,[dec_dig] => 0,[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => ,[view_add] => ,[ext_read] => ,[ext_write] => )),[clacs] => Array ([431] => Array ([id] => 431,[table_id] => 21,[calculate] => // Получаем сумму содержимого полей "Сумма" таблицы "Позиции счета", где поле "Счет" равно номеру счета. $sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1 WHERE status=0 AND f1='".$line['Контактные данные']['ID']."'"; $res = mysql_query($sqlQuery); $row = mysql_fetch_array($res); $line['Контактные данные']['Баланс'] = $row['summa'];,[old_format] => 0,[link_fields] => Array (),[conditions] => Array ([0] => Array ([type] => 2,[param] => 1281,[param2] => 0))))), Array ([id] => 2,[user_id] => 1,[add_time] => 2013-03-15 06:42:41,[status] => 0,[f231] => rasika,[f241] => rani,[f251] => Rasika Rani,[f281] => rasika-rani.psdg@mail.ru,[f291] => мисмимчсми,[f301] => 781,[f311] => 11,[f361] => ,[f1241] => ,[f1281] => 0,[r] => 0,[u] => 0,[Контактные данные] => Array ([Баланс] => )), Array ([id] => 2,[user_id] => 1,[add_time] => 2013-03-15 06:42:41,[status] => 0,[f231] => rasika,[f241] => rani,[f251] => Rasika Rani,[f281] => rasika-rani.psdg@mail.ru,[f291] => мисмимчсми,[f301] => 781,[f311] => 11,[f361] => ,[f1241] => ,[f1281] => 0,[r] => 0,[u] => 0), 431) called at [/home/3aka3/public_html/include/functions1.php:266] #2 calc_line(Array ([id] => 21,[cat_id] => 1,[table_num] => 1,[name_table] => Контактные данные,[full_name] => ,[add_text] => ,[edit_text] => Контактные данные,[def_sort] => ,[help] => ,[subtable] => 0,[crypt] => 0,[view_sql] => ,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[auto_save] => 1,[LOP] => 100,[fix_search_submit] => 0,[user_table_link] => a:8:{s:5:"login";s:3:"231";s:8:"password";s:3:"241";s:3:"fio";s:3:"251";s:6:"e_mail";s:3:"281";s:5:"phone";s:3:"291";s:8:"group_id";s:3:"301";s:7:"user_id";s:3:"311";s:6:"invite";s:1:"2";},[display] => Array ([name_table] => Контактные данные,[full_name] => ,[add_text] => ,[edit_text] => Контактные данные,[def_sort] => ,[help] => ),[user_table_fields] => Array ([login] => 231,[password] => 241,[fio] => 251,[e_mail] => 281,[phone] => 291,[group_id] => 301,[user_id] => 311,[invite] => 2),[vis] => 1,[add] => 0,[del] => 0,[arc] => 0,[imp] => 0,[exp] => 0,[adf] => 0,[bed] => 0,[ext] => 0,[view_tb] => 1,[view] => 1,[view_lnk] => 1,[int_names] => Array ([f311] => 311,[id] => 191,[user_id] => 201,[add_time] => 211,[status] => 221,[f231] => 231,[f241] => 241,[f251] => 251,[f281] => 281,[f291] => 291,[f361] => 361,[f301] => 301,[f1241] => 1241,[f1281] => 1281),[link_tables] => Array (),[table_fields] => Array ([311] => Array ([id] => 311,[table_id] => 21,[field_num] => 1,[name_field] => Пользователь,[type_field] => 7,[type_name] => пользователь,[type_value] => 0|0,[default_value] => 0,[type_value_js] => 0|0,[default_value_js] => 0,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 0,[int_name] => f311,[fix_search_on] => 0,[scw_set] => Array (),[groupe] => 0,[use_rights] => 0,[display_groups] => ,[read] => 1,[write] => 1,[rights_ex] => Array ()),[191] => Array ([id] => 191,[table_id] => 21,[field_num] => 2,[name_field] => ID,[type_field] => 10,[type_name] => число,[type_value] => ,[default_value] => {autonumber},[type_value_js] => ,[default_value_js] => {autonumber},[javascript] => ,[help] => ,[main] => 1,[unique] => 1,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 1,[int_name] => id,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array ()),[201] => Array ([id] => 201,[table_id] => 21,[field_num] => 3,[name_field] => Кто добавил,[type_field] => 11,[type_name] => пользователь,[type_value] => 0|0,[default_value] => {current},[type_value_js] => 0|0,[default_value_js] => {current},[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 2,[int_name] => user_id,[fix_search_on] => 0,[scw_set] => Array (),[groupe] => 0,[use_rights] => 0,[display_groups] => ,[read] => 1,[write] => 1,[rights_ex] => Array ()),[211] => Array ([id] => 211,[table_id] => 21,[field_num] => 4,[name_field] => Время добавления,[type_field] => 12,[type_name] => дата/время,[type_value] => 1,[default_value] => {cur.time},[type_value_js] => 1,[default_value_js] => {cur.time},[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 3,[int_name] => add_time,[fix_search_on] => 0,[scw_set] => Array (),[display_time] => 1,[read] => 1,[write] => 1,[rights_ex] => Array ()),[221] => Array ([id] => 221,[table_id] => 21,[field_num] => 5,[name_field] => Статус записи,[type_field] => 13,[type_name] => список,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 4,[int_name] => status,[fix_search_on] => 0,[scw_set] => Array (),[list_values] => Array ([0] => ),[read] => 1,[write] => 1,[rights_ex] => Array ()),[231] => Array ([id] => 231,[table_id] => 21,[field_num] => 6,[name_field] => Логин,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 5,[int_name] => f231,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[241] => Array ([id] => 241,[table_id] => 21,[field_num] => 7,[name_field] => Пароль,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 6,[int_name] => f241,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[251] => Array ([id] => 251,[table_id] => 21,[field_num] => 8,[name_field] => ФИО,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 7,[int_name] => f251,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => 1,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[281] => Array ([id] => 281,[table_id] => 21,[field_num] => 9,[name_field] => E-mail,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 1,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 8,[int_name] => f281,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => 1,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[291] => Array ([id] => 291,[table_id] => 21,[field_num] => 10,[name_field] => Телефон,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 9,[int_name] => f291,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => 1,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[361] => Array ([id] => 361,[table_id] => 21,[field_num] => 11,[name_field] => Адрес доставки,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 1,[fast_edit] => 0,[pp] => 10,[int_name] => f361,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[301] => Array ([id] => 301,[table_id] => 21,[field_num] => 12,[name_field] => Группа,[type_field] => 14,[type_name] => группа,[type_value] => 0|0|777,[default_value] => 777,[type_value_js] => 0|0|777,[default_value_js] => 777,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 11,[int_name] => f301,[fix_search_on] => 0,[scw_set] => Array (),[groupe] => 0,[use_rights] => 0,[display_groups] => 777,[read] => 1,[write] => 1,[rights_ex] => Array ()),[1241] => Array ([id] => 1241,[table_id] => 21,[field_num] => 13,[name_field] => Паспортные данные,[type_field] => 3,[type_name] => текст,[type_value] => ,[default_value] => ,[type_value_js] => ,[default_value_js] => ,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 1,[fast_edit] => 0,[pp] => 12,[int_name] => f1241,[fix_search_on] => 0,[scw_set] => Array (),[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => 1,[view_add] => 1,[ext_read] => ,[ext_write] => ),[1281] => Array ([id] => 1281,[table_id] => 21,[field_num] => 14,[name_field] => Баланс,[type_field] => 1,[type_name] => число,[type_value] => 10/0,[default_value] => 0,[type_value_js] => 10/0,[default_value_js] => 0,[javascript] => ,[help] => ,[main] => 0,[unique] => 0,[summa] => 0,[reduce] => ,[hidden] => ,[width] => 0,[fixed_scroll] => 0,[fixed_scroll_width] => 0,[group_field] => 0,[mult_value] => 0,[fast_edit] => 0,[pp] => 13,[int_name] => f1281,[fix_search_on] => 0,[scw_set] => Array (),[all_dig] => 10,[dec_dig] => 0,[read] => 1,[write] => 1,[rights_ex] => Array (),[view] => 1,[view_tb] => ,[view_edit] => ,[view_add] => ,[ext_read] => ,[ext_write] => )),[clacs] => Array ([431] => Array ([id] => 431,[table_id] => 21,[calculate] => // Получаем сумму содержимого полей "Сумма" таблицы "Позиции счета", где поле "Счет" равно номеру счета. $sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1 WHERE status=0 AND f1='".$line['Контактные данные']['ID']."'"; $res = mysql_query($sqlQuery); $row = mysql_fetch_array($res); $line['Контактные данные']['Баланс'] = $row['summa'];,[old_format] => 0,[link_fields] => Array (),[conditions] => Array ([0] => Array ([type] => 2,[param] => 1281,[param2] => 0))))), Array ([id] => 2,[user_id] => 1,[add_time] => 2013-03-15 06:42:41,[status] => 0,[f231] => rasika,[f241] => rani,[f251] => Rasika Rani,[f281] => rasika-rani.psdg@mail.ru,[f291] => мисмимчсми,[f301] => 781,[f311] => 11,[f361] => ,[f1241] => ,[f1281] => 0,[r] => 0,[u] => 0,[Контактные данные] => Array ([Баланс] => )), Array ([id] => 431,[table_id] => 21,[calculate] => // Получаем сумму содержимого полей "Сумма" таблицы "Позиции счета", где поле "Счет" равно номеру счета. $sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1 WHERE status=0 AND f1='".$line['Контактные данные']['ID']."'"; $res = mysql_query($sqlQuery); $row = mysql_fetch_array($res); $line['Контактные данные']['Баланс'] = $row['summa'];,[old_format] => 0,[link_fields] => Array (),[conditions] => Array ([0] => Array ([type] => 2,[param] => 1281,[param2] => 0))), ) called at [/home/3aka3/public_html/view_line2.php:1412]

[wondertalik]

$sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1 WHERE status=0 AND f1='".$line['Контактные данные']['ID']."'";
$res = mysql_query($sqlQuery) or die(mysql_error()."<br>".$sqlQuery);
$row = mysql_fetch_array($res);

Попробуйте только такой код. Скорее всего запрос не выполняется.

[serg777]

попробовал, вот результат

Unknown column 'f1' in 'where clause'
SELECT sum(f1261) as summa FROM f_data1 WHERE status=0 AND f1=''

$sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1 WHERE status=0 AND f1='".$line['Контактные данные']['ID']."'";
$res = mysql_query($sqlQuery) or die(mysql_error()."<br>".$sqlQuery);
$row = mysql_fetch_array($res);

что-то я, по-моему, с полями напутал...

в моем случае

Есть таблица 'Контактные данные ', в ней

1. поле 'Баланс', в котором в итоге должна отобразиться сумма (table=21&field=1281)
2. поле 'ID', которое связывают эту таблицу со второй таблицей (table=21&field=191)

Вторая таблица - 'Все заказы ', в которой

1. поле 'Сумма баланс', из которого мы берем сумму (table=1&field=1261)
2. поле 'Код клиента', через которое связано 2 таблицы (table=1&field=871)

Разбирался, пока не получилось...
последняя моя попытка выглядела так:

$sqlQuery = "SELECT sum(f1261) as summa FROM ".DATA_TABLE."1 WHERE status=0 AND f871='".$line['Контактные данные']['ID']."'";
$res = mysql_query($sqlQuery) or die(mysql_error()."<br>".$sqlQuery);
$row = mysql_fetch_array($res);
$line['Контактные данные']['Баланс'] = $row['summa'];

Сообщение отредактировал serg777: 22 Март 2013 - 22:10

[wondertalik]

echo $sqlQuery;

А вообще просто можете дать доступ. Так будет быстрее.

[serg777]

ок

Сообщение отредактировал serg777: 22 Март 2013 - 23:05

[wondertalik]

Все. Изучите внимательно документацию.

Сообщение отредактировал wondertalik: 22 Март 2013 - 23:03

[serg777]

спасибо Вам огромное. Действительно, теперь всё работает.

Да, я как раз пытаюсь изучать. уделю этому больше внимания.