Aciu uz pagalba. Veikia.
"gopas" <netikras@jamailas.lt> wrote in message
news:h6gfk0$n2c$1@trimpas.omnitel.net...
> po duombazes sukurimo idek eilute
> mysql_select_db("content");
>
> "gedas" <neturiu@gmail.com> wrote in message
> news:h6gcic$i5u$1@trimpas.omnitel.net...
>> Naudoju toki scriptuka, kuris automatiskai sukuria DB:
>> <?
>> $sql = "CREATE DATABASE content";
>>
>> $connection = @mysql_connect("localhost","root","") or
>> die(mysql_error());
>> $result = @mysql_query($sql,$connection) or die(mysql_error());
>> if ($result) {$msg ="<P>Database has been created!</P>";}
>> ?>
>> <HTML>
>> <HEAD>
>> <TITLE>Create a MySQL Database</TITLE>
>> </HEAD>
>> <BODY><? echo "$msg"; ?>
>> </BODY>
>> </HTML>
>>
>> Taip pat noriu, kad automatiskai sukurtu lentele "users", skriptuka
>> papildau tokiomis komandomis:
>>
>> $sql = "USE content";
>> $sql = "CREATE TABLE `users` (
>> `user_id` int(10) unsigned NOT NULL auto_increment,
>> `email` varchar(40) NOT NULL,
>> `registration_date` datetime NOT NULL,
>> PRIMARY KEY (`user_id`),
>> UNIQUE KEY `email` (`email`),
>> KEY (`email`,`pass`)
>> )";
>>
>> Ismeta tokia pranesima, "No database selected" ir nesukuria nei DB, nei
>> lenteles. Kame cia gali buti beda? Dekoju is mintis.
>
>
>