It creates way different table cretion line than phpmyadmin, and executing the sql gives error...
Code: Select all
function create_header()
{
$d = "";
$h = "";
$fields = mysql_list_fields($this->db, $this->table, $this->cnx);
$h = "CREATE TABLE `" . $this->table . "` ( \r\n ";
for($i=0; $i<mysql_num_fields($fields); $i++)
{
$name = mysql_field_name($fields, $i);
$flags = mysql_field_flags($fields, $i);
$len = mysql_field_len($fields, $i);
$type = mysql_field_type($fields, $i);
$h .= "`$name` $type($len) $flags, \r\n ";
if(strpos($flags, "primary_key"))
$pkey = "PRIMARY KEY (`$name`) ";
else
$pkey=" ";
}
$h = substr($h, 0, strlen($d) - 1);
$h .= "$pkey) TYPE=MyISAM;\r\n";
return($h);
}Code: Select all
CREATE TABLE `haku_sana` (
`sana` string(30) not_null primary_key,
`kutsuja` int(20) not_null,
`vuosi` int(6) not_null,
`kuukausi` int(4) not_null,
) TYPE=MyISAM;Code: Select all
CREATE TABLE `haku_sana` (
`sana` varchar(30) NOT NULL default '',
`kutsuja` bigint(20) NOT NULL default '0',
`vuosi` smallint(6) NOT NULL default '0',
`kuukausi` tinyint(4) NOT NULL default '0',
UNIQUE KEY `sana` (`sana`)
) TYPE=MyISAM;feyd | Help us, help you. Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]