Article View: dk.edb.database
Article #15028Re: error
From: Peter Brodersen
Date: Sun, 22 Jul 2001 06:50
Date: Sun, 22 Jul 2001 06:50
40 lines
2003 bytes
2003 bytes
On Sun, 22 Jul 2001 05:12:51 +0200, "hehe" <clark@cool.dk> wrote:
> $table = "nyheder";
> mysql_query("$table")
> or die(mysql_error());
>
> show_tables($table);
For det f�rste vil jeg g� ud fra at du bruger PHP; det n�vner du ikke.
Men ovenst�ende kode giver ikke s� meget mening:
1. F�rst fors�ger du at lave f�lgende query:
mysql_query("nyheder")
Det er ganske enkelt ikke en gyldig query.
2. Derefter fors�ger du at udf�re en PHP-funktion ved navn show_tables
- en s�dan findes heller ikke.
I stedet skal du smide "show tables" ind i din query, alts� f�lgende i
stedet for ovenst�ende kode:
<?
$result = mysql_query("show tables")
or die(mysql_error());
?>
... og s� evt. en alm. l�kke til at printe resultatet ud, fx:
<?
print "<b>Tabeller:</b><br>\n";
while (list($tabelnavn) = mysql_fetch_row($result) ) {
print "$tabelnavn<br>\n";
}
?>
--
- Pede
Professionel n�
Technical Details
Message-ID:
<bmtkltschs5ke8upmor9ub584v0givrjor@news.worldonline.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!cyclone2.usenetserver.com!usenetserver.com!news.tele.dk!212.54.64.131!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mailReferences:
<9jdgg9$gfh$1@news.cybercity.dk>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,ef0de9ade0bc178e X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-07-21 23:52:07 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!cyclone2.usenetserver.com!usenetserver.com!news.tele.dk!212.54.64.131!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail From: Peter Brodersen <professionel@nerd.dk> Newsgroups: dk.edb.database Subject: Re: error Message-ID: <bmtkltschs5ke8upmor9ub584v0givrjor@news.worldonline.dk> References: <9jdgg9$gfh$1@news.cybercity.dk> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 40 Date: Sun, 22 Jul 2001 08:50:32 +0200 NNTP-Posting-Host: 213.237.11.129 X-Complaints-To: news-abuse@wol.dk X-Trace: news000.worldonline.dk 995784627 213.237.11.129 (Sun, 22 Jul 2001 08:50:27 MET DST) NNTP-Posting-Date: Sun, 22 Jul 2001 08:50:27 MET DST Organization: Customer of Tiscali A/S (World Online)