PHP Count problem

Ziycon · 24-10-2006 06:05PM #1

Below is the function i have, basicly it will count the first record in the DB table but no more, all im trying to do it return a number of how many rows are in the table 'hl', can anyone help?

function count_hl()
{
	$sql = 'SELECT COUNT(id) FROM hl';
	$data = mysql_query($sql);
	$result = mysql_fetch_row($data);
	
	return $result;
}

seamus · 24-10-2006 06:55PM

Weird. Have you tried count(*) instead of count(id). There is more than one row in the DB right?

Ziycon · 24-10-2006 07:36PM

Ye, there is more then one row in the table and i have tried (*) but no luck, still wont return the count number!?

seamus · 24-10-2006 08:46PM

Can you post up the code in which you use this function?

Try this

function count_hl()
{
	$sql = 'SELECT COUNT(id) as num_rows FROM hl';
	$data = mysql_query($sql);
	$result = mysql_fetch_array($data);
	
	return $result['num_rows'];
}

Ziycon · 25-10-2006 12:28AM

This is how its being called:

<table width="95%" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td colspan="2" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:15px;">
			<u>Topic Name</u><br/>
			&nbsp;
		</td>
	</tr>
	<?php
	$rows = count_hl();
	for($counter = 1; $counter <= $rows; $counter++)
	{
		echo'
		<tr>
			<td width="10" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;">
				>>
			</td>
			<td width="100%" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;">
				&nbsp;<a href="topic_desc.php?id='.$counter.'">';echo name_hl($counter); echo'</a>';
		echo'
			</td>
		</tr>';
	}
?>
</table>

Adam · 25-10-2006 12:57AM

	$sql = "SELECT COUNT(id) FROM table"; 
	$result = mysql_query($sql);
	$row = mysql_fetch_array($result);
	
	echo ($row['COUNT(id)']);

Simple example, should be easy for you to work up into a function from there.

Ziycon · 25-10-2006 01:01AM

Nice one lads, got it working.

Appreciated!

The Corinthian · 26-10-2006 01:11PM

Ziycon wrote:

Below is the function i have, basicly it will count the first record in the DB table but no more, all im trying to do it return a number of how many rows are in the table 'hl', can anyone help?

You can also just add the bit in red below:

function count_hl()
{
	$sql = 'SELECT COUNT(id) FROM hl';
	$data = mysql_query($sql);
	$result = mysql_fetch_row($data);
	
	return $result[COLOR="Red"][0][/COLOR];
}

PHP Count problem

Comments