Row Count

AndrewWest

I'm curious how you count the rows in a database. I want to know actually how many rows, not the last ID.

I'm know I'm going to end up having to use:

$something_count = count($something);

But I'm not sure what I need to be counting.

Thanks,
Andrew

LordShryku

$sql = "SELECT count(*) FROM table";
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
echo $row[0];

No problem 😉

AndrewWest

Well it works... when the forum == row, but that's not what I'm looking for.

I don't want it to call from a row.. I want it to count ALL rows.. not just one row.

Say you have

id name blah blah
1 blah no yes
2 blac no no

Then for every ID that's there (No matter what the ID is) it should Count 1.

So even if it has

id
1
2
5
99
103
345

It would recognize still only 6 rows, so the count would come back 6

LordShryku

That's what count(*) will do. What's it not returning?

AndrewWest

It's returning only the column count of each row.

LordShryku

That makes no sense at all. How on earth are you getting column counts? SQL doesn't count columns...

AndrewWest

Maybe I'm just looking at this wrong, and giving the wrong idea for what I need? Since I don't know what it is, then I can't say exactly for sure what I need, but what I'm going to use it to implement is ..

If a forum has 0 threads (so if there are no ID's) then it will include a template

if ($count == 0) {
include("W:/www/modulization/templates/forum_none.php");
}

Is a example of what I'm tyring to figure out.

tommynanda

I dont see why Lord Shryku's method isnt working for you... but try this...

$result = mysql_query("SELECT * FROM table_name");
$count = mysql_num_rows($result);
if ($count == 0) { 
include("W:/www/modulization/templates/forum_none.php"); 
} 
else{
include("something.php");
}

But this eats up your CPU resources... this is an inefficient way of doing it... LordShryku's suggestion is exactly the way to do it... I dont know y it isnt working for you... but this is how LordShryku suggested...

$query = "SELECT COUNT(*) FROM table_name";  // Total # of rows
$result = mysql_query($query);
$count = mysql_result($result,0);
if ($count == 0) { 
include("W:/www/modulization/templates/forum_none.php"); 
} 
else{
include("something.php");
}

Double check your table 😉

Good Luck
TommYNandA

AndrewWest

Could it be, I'm on a windows server?

<?php
$f = $_GET['f'];

$topic = mysql_query("SELECT * FROM topics WHERE forum=$f ORDER BY id DESC");


include("W:/www/modulization/templates/thread_list_top.php");

$query = "SELECT COUNT(*) FROM topics";  // Total # of rows
$result = mysql_query($query);
$count = mysql_result($result,0);
if ($count == 2) {
include("W:/www/modulization/templates/forum_none.php");
}

while ($row = mysql_fetch_array($topic)) {
$row['title'] = "<a href='$siteurl/index.php?page=showtopic&t=" .$row['id']. "'>$row[title]</a>";
   include("W:/www/modulization/templates/thread_list.php");
}


include("W:/www/modulization/templates/thread_list_bottom.php");


?>

LordShryku

Could be. On Windows, I'd include like this:

include('W:\www\modulization\templates\forum_none.php');

Single quotes so it doesn't error on the Windows slashes. You may want to also consider using require_once instead of include. That way it bombs with an error if it can't find the file.

tommynanda

wats the output? did u check ur table for number of rows?

ID Field 1 Field2
1 slkfjsd ksdfjlksdjf
2 ksjdflkds sdklfjklsdjf
6 ksjdkflj lksdjfkljdf

if this is your table $count gets the value 3... Is this wat u looking for?

AndrewWest

OMG - I feel like a waste of brain..

I forgot to make it:

$query = "SELECT COUNT(*) FROM topics WHERE forum=$f";

Opposed to:

$query = "SELECT COUNT(*) FROM topics

This is what we call a DOH!

slimjim

Ok I am really close now...

I got it so that it works sorta the way i want it too using the WHERE statement BUT

It only shows categoryb names if there are links in subcat/subcat

I need it to show the other categoryb names even though there is none listed in subcat/subcat so that it shows a count of ( 0 ) for the others.

$query = "SELECT s.subcat, 
                 COUNT(s.subcat) AS num, 
                 c.* 
          FROM subcat AS s, 
               categoryb AS c
               WHERE categoryg='$cate' AND s.subcat=c.categoryb
          GROUP BY c.catb_id"; 
            $result = mysql_query($query)                                    

       or die ("Couldn't execute query: ".mysql_error());