+ Reply to Thread
Results 1 to 3 of 3

Thread: help with mysql

  1. #1
    brentcatoe is offline x10Hosting Member brentcatoe is an unknown quantity at this point
    Join Date
    Sep 2005
    Posts
    7

    help with mysql

    I am trying to run this script to create a table for my login and registration system. Here is the code

    CREATE TABLE `users`
    ( `userid` int(25) NOT NULL auto_increment,
    `first_name` varchar(25) NOT NULL default '',
    `last_name` varchar(25) NOT NULL default '',
    `email_address` varchar(50) NOT NULL default '',
    `username` varchar(25) NOT NULL default '',
    `PASSWORD` varchar(255) NOT NULL default '',
    `info` text NOT NULL,
    `user_level` enum('0','1','2','3') NOT NULL default '0',
    `signup_date` datetime NOT NULL default '0000-00-00 00:00:00',
    `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
    `activated` enum('0','1') NOT NULL default '0',
    `files_uploaded` int(25) NOT NULL default '0',
    `files_uploaded_size` int(25) NOT NULL default '0',
    `ip3` varchar(20) NOT NULL default '',
    `ip2` varchar(20) NOT NULL default '',
    `ip` varchar(20) NOT NULL default ''
    primary key ('userid')
    )

    Where does the problem seem to be, I cannot figure it out. It is probably some stupid mistake because I am half asleep right now but if anyone coudl help I would appreciate it.

    Thanks,

  2. #2
    TheJeffsta's Avatar
    TheJeffsta is offline x10 Lieutenant TheJeffsta is an unknown quantity at this point
    Join Date
    Sep 2005
    Location
    New Zealand
    Posts
    492

    Re: help with mysql

    Have you tried publishing the page to a server (its serverside code)
    TheJeffsta (Jeffrey N)

    "No matter how much you try, the end result will always end up the way you DO NOT want it!"

  3. #3
    NielsJanssen is offline x10Hosting Member NielsJanssen is an unknown quantity at this point
    Join Date
    Jun 2005
    Location
    Europe, The Netherlands
    Posts
    74

    Re: help with mysql

    Where have you put the code? Cauz the best place to put it would be phpmyadmin.



+ Reply to Thread

Similar Threads

  1. [PHP] MySQL and PHP
    By Bryon in forum Tutorials
    Replies: 43
    Last Post: 03-24-2011, 07:27 AM
  2. MySQL server address HELP :S
    By rinnerz.com in forum Free Hosting
    Replies: 5
    Last Post: 07-09-2006, 10:25 AM
  3. in here MySQL version????
    By winUSD in forum Free Hosting
    Replies: 4
    Last Post: 05-09-2006, 08:44 AM
  4. Have a problem with my forum
    By tikloos in forum Scripts & 3rd Party Apps
    Replies: 43
    Last Post: 01-19-2006, 01:14 AM
  5. MySQL problem
    By pensoftware in forum Free Hosting
    Replies: 3
    Last Post: 10-30-2005, 12:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers