[rouzbeh]

when i creating a table for users of my server with mysql phpMyAdmin,have undefined error and canceled
i have 121 fields in this table
whats the problem?

[doreto]

Did you named your table? , scroll to top and it should give you error name

off: pink browser o.0

[rouzbeh]

yes.my table have name users

[arakuta]

try a SQL command in you pawn

pawn Код:

mysql_function_query(handle,"CREATE TABLE IF NOT EXISTS `users` (`id` int(11) NOT NULL, AUTO_INCREMENT, `name` VARCHAR(24) NOT NULL,`password` VARCHAR(32))", false, "", "");

[rouzbeh]

but we have 121 columns.

[Vince]

Exactly. So read up on database normalization and relations. There is no advantage in using SQL if you're just going to treat is as a file system.

[rouzbeh]

but i did read mysql is fastest and i using for show userpanel is site too

Quote:

So read up on database normalization and relations.

i dont know your means.can you say easyer?

[Scenario]

Quote:

Originally Posted by rouzbeh but i did read mysql is fastest

Whatever you're reading is wrong.

****** search "MySQL database normalization and relations" and read the stuff from the official MySQL website- it's important!

[rouzbeh]

Solved
i first write top 100 in one file and export that.then write 21 other and import 100 fields.
i think that is phpmyadmin's bug!!
very thanks for all replies!!