Database Query / Creating Tables

[Fluke667]

i just made this:

https://vborg.vbsupport.ru/showthread.php?t=117724


Can any1 Help me with the Table & Colums needs to be created?

[BirdOPrey5]

That code doesn't even look like it works... I don't even know what it's supposed to do...

That said all we know about the table is from here:

INSERT INTO vb_linklist  
                       (name,link,kategorie)

So you need to create a table called "linklist" with at least the fields name, link, and kategorie (which I now realize was supposed to be "category.")

I assume it should have some type of unique index as well even though it is not used in the code.

If you're going to create the queury in PHP (such as mod install code) you need to account for the table prefix, if you're just creating it yourself in phpmyadmin just fill it in yourself.

In PHP use this query:

PHP Code:

$db->query_write("CREATE  TABLE IF NOT EXISTS `". TABLE_PREFIX ."linklist`  (  `id` int( 11  )  NOT  NULL  auto_increment ,
 `name` varchar( 255  )  NOT  NULL ,
 `link` varchar( 2000  )  NOT  NULL ,
 `kategorie` text NOT  NULL ,
 PRIMARY  KEY (  `id`  )  )  "); 


If doing your own direct query-

 CREATE  TABLE  `linklist` (  `id` int( 11  )  NOT  NULL  auto_increment ,
 `name` varchar( 255  )  NOT  NULL ,
 `link` varchar( 2000  )  NOT  NULL ,
 `kategorie` text NOT  NULL ,
 PRIMARY  KEY (  `id`  )  ) ;

change "linklist" to accommodate any table prefix you use.