PHP-MySQL (INT PRIMARY KEY AUTO_INCREMENT)
| From: | maurice at genesis dot maranatha dot edu | 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??