WayneO Posted February 15, 2003 Share Posted February 15, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/155-create-table/ Share on other sites More sharing options...
effigy Posted February 16, 2003 Share Posted February 16, 2003 i think it\'s your code... try this: mysql_query(\"CREATE TABLE tmp_balances(bal_id int(16) NOT NULL AUTO_INCREMENT, UNIQUE bal_id(bal_id))\") or die(mysql_error()); Quote Link to comment https://forums.phpfreaks.com/topic/155-create-table/#findComment-466 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.