WayneO

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

When trying to run the following Mysql instruction mysql_connect($db_host, $db_user, $db_pass)or die(mysql_error()); mysql_select_db ($db)or die(mysql_error()); mysql_query(\"CREATE TABLE tmp_balances (bal_id int(16) NOT NULL AUTO_INCREMENT, UNIQUE bal_id(bal_id)) or die(mysql_error())\"); I receive the following Error Table \'habladb.tmp_balances\' doesn\'t exist It appears the CREATE TABLE is not functioning. Anyone with an idea why ? Wayne