This is easy

Chrysanthus

How do i count enterys in a row ihavsimpely forgott it.

i wanna count how many post ther ar in the POST row....

i have remembers this mutch sow far!!


$result = mysql_query("SELECT COUNT(*) FROM guestbook where Post="";",$starta); 
				echo mysql_result($result, 0);?>

stolzyboy

check out [man]mysql_num_rows[/man]

Chrysanthus

Yeah that do i know already ... i wonder if ther is a quiqer way to only count the specified row!

drawmack

What do you mean by only counting a specific row, a specific row is always going to have 0 or 1 occurances. Do you mean column? Well in that case you'll always have as many columns as you have records that match your where clause.

For example

SELECT COUNT(*) FROM table_name

will return the same value as

SELECT COUNT(ID) FROM table_name

(as long as ID is a valid field name for this table.

Now maybe you only want records where a specific field has data in it and it not blank then you would do this

SELECT COUNT(*) FROM table_name WHERE field_name != ""

understand?

Chrysanthus

Yes that is what i wanted....

The thing before i used this


<b>Total Posts:
			<?php 
			$result = mysql_query("SELECT * FROM guestbook",$starta);
			$num_rows = mysql_num_rows($result);
			echo "$num_rows \n"; ?> 
			</b>

but i hade a thount that if i counte only the specified columns like Post column then i woulde not make a stupide query on the holle tabel ....

or is that the right way or not?