DeepSeek 🤖 Posted February 17, 2003 Share Posted February 17, 2003 The Insert Select command is new to me. Would someone please tell me the error in the following: mysql_query (\"INSERT INTO tmp_balances (bal_id,CustId,PAID,USED,Bal) SELECT ($CustId,sum($payment),sum($useage),sum($useage)-sum($payment)from transactions GROUP BY CustId)\")or die(mysql_error()); Thanks Link to comment https://forums.phpfreaks.com/topic/163-insert-select-question/ Share on other sites More sharing options...
DeepSeek 🤖 Posted February 18, 2003 Share Posted February 18, 2003 Yes... You are not inserting the bal_id.... P. Link to comment https://forums.phpfreaks.com/topic/163-insert-select-question/#findComment-482 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.