SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    May 2001
    Location
    East Harlem, Spanish Harlem, El Barrio
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Problem with a php install page

    Hi,
    I am trying to create an install.php page for my Alumnus Database. But I keep getting the following error.

    Successfully created the marty database.
    1064: You have an error in your SQL syntax near '(mbr_id SMALLINT(5) DEFAULT '0' NOT NULL AUTO_INCREMENT,fname varchar(15) NOT NUL' at line 1

    The code of the 'install.php' page is as follows:

    <?php
    include "common_db.inc";

    $dbname = "marty";

    $user_tablename = "user";
    $user_table_def = "mbr_id SMALLINT(5) DEFAULT '0' NOT NULL AUTO_INCREMENT,";
    $user_table_def .= "fname varchar(15) NOT NULL DEFAULT ' ', ";
    $user_table_def .= "lname varchar(15) NOT NULL DEFAULT ' ', ";
    $user_table_def .= "grad_year smallint(4) NOT NULL DEFAULT '0', ";
    $user_table_def .= "status varchar(7) NOT NULL DEFAULT '', ";
    $user_table_def .= "location varchar(25) DEFAULT NULL, ";
    $user_table_def .= "email varchar(50) NOT NULL DEFAULT '', ";
    $user_table_def .= "url varchar(50) NULL,DEFAULT '', ";
    $user_table_def .= "comments text, ";
    $user_table_def .= "username varchar(15) NOT NULL DEFAULT '', ";
    $user_table_def .= "password varchar(100) NOT NULL DEFAULT '', ";
    $user_table_def .= "occupation varchar(30) DEFAULT NULL, ";
    $user_table_def .= "interests varchar(30) DEFAULT NULL, ";
    $user_table_def .= "registerdate date NOT NULL DEFAULT '0000-00-00', ";
    $user_table_def .= "pic varchar(25) DEFAULT NULL, ";
    $user_table_def .= "PRIMARY KEY (mbr_id), ";
    $user_table_def .= "UNIQUE KEY mbr_id (mbr_id) ";

    //$link_id = db_connect();
    //if(!$link_id) die(sql_error());

    if(!mysql_query("CREATE DATABASE $dbname")) die(sql_error());

    echo "Successfully created the $dbname database.<br>";

    if(!mysql_select_db($dbname)) die(sql_error());

    if(!mysql_query("CREATE TABLE $user ($user_table_def)")) die(sql_error());

    ?>

    Can you spot any obvious errors. I code most of my code from the book "Begining PHP4" by Wrox.

    Any help would be helpfull.

  2. #2
    SitePoint Member
    Join Date
    May 2001
    Location
    East Harlem, Spanish Harlem, El Barrio
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I figured it out. Thanks all.

  3. #3
    SitePoint Wizard Aes's Avatar
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    3,392
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For curiosity's sake, what was the error?

    -Colin
    Colin Anderson
    Ambition is a poor excuse for those without
    sense enough to be lazy.

  4. #4
    SitePoint Member
    Join Date
    May 2001
    Location
    East Harlem, Spanish Harlem, El Barrio
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry, I should have put that there.

    In the script, there were a few DEFAULT without anything afterwards and I also changed a variable in my common_db.inc file which may have helped.

  5. #5
    SitePoint Wizard Aes's Avatar
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    3,392
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Jose
    Sorry, I should have put that there....
    Bleh. Don't worry about it! Thanks though. Glad you fixed your problem.

    -Colin
    Colin Anderson
    Ambition is a poor excuse for those without
    sense enough to be lazy.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •