On Thu, 06 Sep 2001 14:06:59 +0200, Kim Schulz <kim@schulz.dk> wrote:
>> SELECT count(art_id) FROM whatever
>>
>> Dog bare husk, at count ikke medtager NULL-værdier.
>
>hvordan får man så denne data ud?
$query = "SELECT count(art_id) FROM table";
$result = mysql_query($query) or die(mysql_error());
list($number) = mysql_fetch_array($result);
eller one lineren
list($number) = mysql_fetch_array(mysql_query("SELECT count(art_id)
FROM table"));
print "Der er ".$number." poster i tabellen";
--
Best Regards / Med Venlig Hilsen,
Guideix Martin Mouritzen Phone +45 43270524
Ringager 2A, 1. Systemudvikler Fax +45 43270556
DK-2605 Brøndby mm@guideix.com
http://www.guideix.com