problem :
I have a HTML form file with 75 fields, drop down menus, text box..etc.

I need to make a database in mysql to catch the information from this form.

but having 75 fields is a bit too much hand coding. So I am using a tool called PHPmyadmin to create the mysql database for me.

Now, here is the problem, when I type in the Table name and how many fields I want, I type in 76 and press OK, the page where you input all the field names and its attributes comes up, but the field type drop down menu is blank, its white.

I have seen that I can make 35 fields without the myadmin tool conking out on me, but anything above this and it does not want to know.

If anyone has this tool installed, please do a tester and if you can make a mysql db with more than 75 fields in the phpmyadmin tool, then tell me what I am doing wrong.

I have finally managed to get everything working together, but this is the only problem that is stopping me from doing my work.

I need some expert help.

Do I need a faster computer?

Thanks alot people.

you can email me directly on saffronflag@aol.com

my system that I am running is below
Pentium 550mhz with 512k cache.
Windows 98se2 with PWS 4.0
IE 6.0
php
phpmyadmin
mysql.
( all latest versions ).
256ram..16meg video card..20gig hd..nothing special.

    i was able to create a table with 76 fields just fine, by going to this section on your database link

    Create new table on database intranet :
    Name : test
    Fields : 76 GO

      I see, just another question, what type of system you running?

      I can create all 76 of the fields, but in the browser window, the drop down list menus are all blank, they are there, but don't show up.

      hmmm..

      maybe I need a fast pc..

      Originally posted by stolzyboy
      i was able to create a table with 76 fields just fine, by going to this section on your database link

      Create new table on database intranet :
      Name : test
      Fields : 76 GO

        are you referring to the drop down to pick varchar, int, etc......
        yes i was able to see that, and i am on a win2k pro install, running php/apache/mysql with athlon xp 2200+ (roughly a 2.0 ghz), with 768 megs ram

          phpmyadmin 2.3.2
          PHP Version 4.3.0RC4
          mysql 3.23.53
          apache 2.0.43

          winxp home edition
          athlon XP 2400
          512 Mb RAM

          page with 76 fields displays within the second, with all the dropdown working 😃

            Why don't you create a table with 35 rows, then add 41 rows in later (35, then 6 if it won't let you insert more than 35 after the table has already been created)

            You should probably report this bug to the phpMyAdmin team too.

              Do you hvae the latest version of PHP MyAdmin, and what browser are you using too?

              It is DEFINITALLY NOT due to the speed of your computer, I've done more than 76 fields on my P133 at home.

                Write a Reply...