Easy COUNT question ?

[Pellefant]

Easy=beginner.....

I would like to write out the number of lines in a table, and use this code below, however I get no number. (I have also tried with only "antal" instead of "$antal" in the query

Happy for help.

<?
$Link = mysql_connect("localhost", "xxxxx", "xxxx");
mysql_select_db("xxxxxx", $Link);

$Query = "SELECT COUNT(*) as $antal FROM statistik" or die (mysql_error());
mysql_db_query ("xxxxxx", $Query, $Link) or die (mysql_error());
?>

<BR><BR><BR><BR><BR>
Visits: <?echo $antal?>

[Stoned_Gecko]

You still need to read the MySQL result with mysql_fetch. The "antall" is just the name of the column that MySQL will return. Here's the right code:

<?php

//Connect to DB
$db_link_id = mysql_connect("localhost", "root", ""); 
mysql_select_db("some_db", $Link); 

//Make the query
$query = "SELECT COUNT(*) as antal FROM statistik";
$result_id = mysql_query($query,$db_link_id) or die (mysql_error());

//Now get the data out of the result
$result = mysql_fetch_assoc($result_id);
$number_of_visits = $result["antal"];
?>

<BR><BR><BR><BR><BR> 
Visits: <?echo $number_of_visits?>

Hope this helps 🙂

[Pellefant]

Works like a charm. Thank you Sir. 🙂