How create a tables? im having troubles

[Felipe93]

No changelogs submitted.string(165) "SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'cast.znote_news' doesn't exist

im using otx 3.5 with znote

 

[Obsdark]

Well, that's not the way to create a table, you are making an INNER JOIN there, which basicaly connects two tables in one, artificialy and temporaly created.

Here you have a link on how to actualy create a table using script, you probably don't need to, and znote_news is a table than exist in certain web stuff created by znote, ZnoteACC, that table is created automaticaly when you install the page to your server.

http://www.w3schools.com/php/php_mysql_create_table.asp


Cheers!
(y) (y)