create table

Article View: dk.edb.database

Article #15024

#15024

From: MiG
Date: Sat, 21 Jul 2001 13:55

26 lines
1618 bytes

Er der nogen som kan sige mig hvad jeg g�r galt?? Jeg f�r en fejlmelding om
at den ikke kunne oprette tabellen

<?PHP
  echo "<h1>Administrer tabeller i databasen p� TheBeat.dk</h1>";
  echo "<h3>Nyheder</h3>";

  $link = mysql_connect("127.0.0.1", "xxx", "xxx");
  if(!mysql_select_db("123"))
    {
      echo "Fejl - kunne ikke connecte til databasen 123";
    }

  $table = "create table nyheder(
    id  integer not null primary key auto_increment,
    date datetime not null,
    name varchar(25) not null,
    text text not null
  )";
  if(!mysql_query("$table"))
    {
      echo "Fejl - kunne ikke oprette tabellen nyheder";
    }

  mysql_close($link);
?>

Technical Details

Message-ID: <9jc1ol$1d70$1@news.cybercity.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.cybercity.dk!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,5170709ee48b044a,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-21 06:57:44 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.cybercity.dk!not-for-mail
From: "MiG" <clark@cool.dk>
Newsgroups: dk.edb.database
Subject: create table
Date: Sat, 21 Jul 2001 15:55:04 +0200
Organization: CyberCity Internet
Lines: 28
Message-ID: <9jc1ol$1d70$1@news.cybercity.dk>
NNTP-Posting-Host: port90.ds1-fh.adsl.cybercity.dk
X-Trace: news.cybercity.dk 995723861 46304 212.242.48.221 (21 Jul 2001 13:57:41 GMT)
X-Complaints-To: abuse@cybercity.dk
NNTP-Posting-Date: Sat, 21 Jul 2001 13:57:41 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200