Making a table in php(need some help)

[Jragon]

Hey,

 

I got a little error when trying to use this code:

<?php
$link = mysql_connect('localhost', 'root', '') or die(mysql_error);

$query = 'CREATE DATABASE IF NOT EXISTS frtdb';
mysql_query($query, $link) or die(mysql_error($link));

mysql_select_db('frtdb', $link);

$query = 'CREATE TABLE track_data (
        track_id        INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        track_name      VARCHAR(32)         NOT NULL,
        track_desc      VARCHAR(250)        NOT NULL,
        track_maker     VARCHAR(32)         NOT NULL,
        track_data      LONGTEXT            NOT NULL,
        PRIMERY KEY (track_id)
        )
        ENGINE=MyISAM';
mysql_query($query, $link) or die(mysql_error($link));

$query = 'CREATE TABLE user_info(
        user_id         INT UNSIGNED        NOT NULL, AUTO_INCREMENT,
        username        VARCHAR(32)         NOT NULL,
        password        VARCHAR(32)         NOT NULL,
        salt            VARCHAR(32)         NOT NULL,
        tracks_posted   INT UNSIGNED        NOT NULL,
        date_joined     DATE                NOT NULL,

        PRIMERY KEY (user_id))
        ENGINE=MyISAM';
mysql_query($query, $link) or die(mysql_error($link));

echo 'Database and Tables made!!'

?>

 

Error:

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 'KEY(track_id)) ENGINE=MyISAM' at line 7

 

Thanks

 

If you can see anymore errors please tell me.

[jskywalker]

PRIMERY KEY

change to:

PRIMARY KEY

 

[Jragon]

Damn i hate not being able to spell!