Help on using count()

[geekisthenewsexy]

hi, i just want to ask something about the count function.

is it ok to use it for counting rows on a table them and displaying not the number of records

but the actual records instead?or is there some other function to go with count to be able to do this?

[chintansshah]

use mysql_num_rows() for number of record in recordset.

[geekisthenewsexy]

yes,but it will just display the number of rows. like,field1 has 3 records etc..how about the actual records?like dog,cat,boy..?

[chintansshah]

then, you should use mysql_fetch_array() after excute your query.

like

$sql = mysql_query("SELECT * FROM country ORDER BY country_name ASC");

while($data = mysql_fetch_array($sql))
{
echo 'Country Name - '.$data['country_name'].' Country id-'.$data['id'].'<br>';
}
echo "</form>";

 

[sandy1028]

Ok Thanks.

 

Occurence of character "<p>" in a value of a particular column.

[geekisthenewsexy]

ok, i'll try it out..thanks