Print count af database

Det kan du vel gøre med echo mysql_num_rows(loadin);

får ikke noget output :( der skulle gerne stå 0 vis der ikke er nogle og der står intet. vis jeg vælger en månde hvor der er nogle i viser den helder ikke noget :(

<?
$SQL = "SELECT * FROM retake_news WHERE month = 'September' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
?>
<h2><? echo mysql_num_rows(loadin);?> September <a href="?page=<? print($_GET['page']);?>&m=Sep">+</a></h2>
<? if($_GET['m'] == "Sep"){?>
<?
    $SQL = "SELECT * FROM retake_news WHERE month = 'September' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br /><? }?>

Eller direkte i basen.
SELECT COUNT(*) AS antal FROM tabel

Min fejl der mangler $ mysql_num_rows($loadin);

kan du ikke give et eks. im not doing so well :P

<?
$SQL = "SELECT * FROM retake_news WHERE month = 'Januar' ORDER BY `id` DESC";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
?>
<h2><? echo($mysql_num_rows(loadin));?>Januar <a href="?page=<? print($_GET['page']);?>&m=Jan">+</a></h2>
<? if($_GET['m'] == "Jan"){?>
<?
    $SQL = "SELECT * FROM retake_news WHERE month = 'Januar' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br /><? }?>

Jeg har bare sat "$" ind foran loadin
<?
$SQL = "SELECT * FROM retake_news WHERE month = 'Januar' ORDER BY `id` DESC";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
?>
<h2><? echo($mysql_num_rows($loadin));?>Januar <a href="?page=<? print($_GET['page']);?>&m=Jan">+</a></h2>
<? if($_GET['m'] == "Jan"){?>
<?
    $SQL = "SELECT * FROM retake_news WHERE month = 'Januar' ORDER BY `id` DESC";
    $loadin = mysql_query($SQL) or die("There is an Error in the database");
    while ($Get = mysql_fetch_object($loadin)){
?>
<div id='contentbox'><h2><?=nl2br($Get->title)?></h2><img src='news/images/news_<?=nl2br($Get->img)?>.jpg' />
<?=nl2br($Get->content)?>
<i class='date'>Posted: <?=nl2br($Get->date)?></i></div>
<? }?><br /><? }?>

Damn tror jeg har set forlænge på den her hjemmeside idag :S

Det er såføljelig rigtig :D tak skal du havde.

Husk et svar :P

Du får et svar