If that query did not work, then maybe the user that you are connecting to the database as does not have table create privileges? The syntax of the query is correct I am a little confused why you are using a text type for those columns And you can probably stand to use unsigned for UiD, since I doubt that you will be using negative values. Note that the value you pass for bigint() only represents the field width that mysql should display. It has nothing to do with the size of the number it can store. On 4/5/01 4:33 PM, "Richard" <[EMAIL PROTECTED]> wrote: > Greetings. > > As "Frank K" wrote for some days ago, I was into the same thing, but I > need help with the following: I am creating a messaging central, which is > quite about the same as a web community if you like, or whatever. The thing > is, I need to save all the users, mailboxes and login dates... But I only > have one database, but infinite tables. Does anyone has any examples or > tips? The following didn't go very well, but probably because I suck in > MySQL: > > $query = "CREATE TABLE $tb_name ( UiD bigint(20) NOT NULL > auto_increment, uName text NOT NULL, uPwd text NOT NULL)"; > > What I was trying to do is to create one table which is called "users", > which contains : > uID (unique id, incremental!) uOnline (boolean) uName and uPWD > > And some other stuff, but as you can see, it did not go very well... Any > help is appriciated! > > > - Richard > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
