Well, that was what I wrote in my post.. I don't get this MySQL that well,
and I didn't find that row very logical at all. But I got this email about
it, so I will read it and keep on reporting.
- Richard
"Lindsay Adams" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
>
--
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]
