PHP-MySQL (INT PRIMARY KEY AUTO_INCREMENT)

From: Date: Fri, 22 Sep 2000 08:15:50 +0000
Subject: PHP-MySQL (INT PRIMARY KEY AUTO_INCREMENT)
Groups: php.general 
Request: Send a blank email to php-general+get-17318@lists.php.net to get a copy of this message
I use this variable, as a varable to mysql_query. $stmt= "CREATE TABLE %s(NAME CHAR(255), EMAIL CHAR(255), CITY CHAR(255), DESCRIPTION CHAR(255), TELEPHONE CHAR (255), ROWID INT PRIMARY KEY AUTO_INCREMENT)"; I use it in another php3 script (a script that make a DB -- mysql_query(sprintf ( $perintah,$tableName), $konek )--) that link to this script. The problem is when I execute this script, the problem appear: the table is not complete!!! only the rowid is exist. But if I change the ROWID with normal int, I can send the data to Database (I use mysql). can anybody help me??

« previous php.general (#17318) next »