display a variable in php

[queenc]

function countsearch($id){
	  $db = NULL;
	  $db = new MyDBHandler;
	  $db -> init();

	  $db -> OpenConnection();
	  $sql="select id,count(keywords) from seeker where userid=".$id;

	  $result = $db->Select($sql);
	  
	  $db -> CloseConnection();
	  return $result;
	}

$nos=$db->countsearch($id);

if it is a ordinary field i will print it as echo $nos[0]["id"]
can anybody tell how to print a count variable...i want to store the count and print it in php

[buddylee17]

Modify the query to assign the count number to the kwcount column:

$sql="select id,count(keywords) AS kwcount from seeker where userid=".$id;

You can then retrieve kwcount in the same way that you retrieve the id column.

[queenc]

can u quote some example i am not able to get you
thanks for your reply