WayneO 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 Quote Link to comment https://forums.phpfreaks.com/topic/163-insert-select-question/ Share on other sites More sharing options...
pallevillesen Posted February 18, 2003 Share Posted February 18, 2003 Yes... You are not inserting the bal_id.... P. Quote Link to comment https://forums.phpfreaks.com/topic/163-insert-select-question/#findComment-482 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.