Table User

[gengar003]

05-27-03 at 02:46 AM filburt1 said this in Post #2
TINYINT is a datatype like long, int, String, etc.
NULL means literally "nothing."

[sql]
ALTER TABLE user ADD yourfield TINYINT(1) NOT NULL DEFAULT 0;
[/sql]

I'm trying to run that query, but I get this error:

Error

SQL-query :
[sql]

ALTER TABLE user ADD yourfield TINYINT( 1 ) NOT NULL DEFAULT0
[/sql]
MySQL said:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT0' at line 1

[Boofo]

You need a space between DEFAULT and 0.

And TINYINT( 1 ) should be TINYINT(1).

[gengar003]

Yes, it's like that when I enter it in, but afterwards, it messes it up...

Anyway, I added in some quotes, and it worked.

[filburt1]

Today at 08:24 PM Boofo said this in Post #12
You need a space between DEFAULT and 0.

And TINYINT( 1 ) should be TINYINT(1).

Whitespace doesn't matter.

[gengar003]

nother question:

HOw would I add in a field to store large amounts of text (10,000 chars) ?

With default 'None'

? I tried, but it just gave me syntax errors...

EDIT: Also, once that was done, how would I set it up so that I could do $post['thatfield'] and have it show the poster's data for that field in the postbit?

[Gary King]

Today at 11:18 AM gengar003 said this in Post #15
nother question:

HOw would I add in a field to store large amounts of text (10,000 chars) ?

With default 'None'

? I tried, but it just gave me syntax errors...

EDIT: Also, once that was done, how would I set it up so that I could do $post['thatfield'] and have it show the poster's data for that field in the postbit?

Answer #1:

[sql]ALTER TABLE `tbl_name` ADD `col_name` TEXT;[/sql]

For default, do you actually want the default to be the string: 'None' , or NULL (nothing there)?

Answer #2:

PHP Code:

$bbuserinfo[col_name] 


[gengar003]

Umm, yeah, the string "none" I would replace TEXT with that?

Also, I want to be able to use $post[col_name] and have it display the info for $post[username]...

get what I'm saying?

[Gary King]

For the query, just use the one I gave, but replacing the tbl_name and col_name of course. TEXT means that it will contain text, to a maximum of 65535 characters.

Just like what I said at Answer #2; place the variable in the postbit wherever you want to display it.

[gengar003]

but, wouldnt' that make the person who's viewing the post see their own info there, instead of the poster's?

[Gary King]

My mistake, it's $post[col_name].