In PHP, How can I get a total number of a rows (count) from a query?

Question

// mysql info
include('config.php');

// How to parse count or other results from a query in php?
$sql = "SELECT * FROM test-table WHERE username LIKE '%test%'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query database', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);

From $row, how can I get a total number of a rows (count) from a query?

Answer 1

amby darling here is your link.

http://www.google.co.uk/search?hl=en&q=in+php+total+number+of+a+rows+%28count%29+from+a+query&btnG=Search&meta=

Answer 2

/ mysql info
include('config.php');

// How to parse count or other results from a query in php?
$sql = "SELECT * FROM test-table WHERE username LIKE '%test%'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query database', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
echo " (". $row->count .")"; //here is the function

Answer 3

$count extensive type = array_pop( mysql_fetch_row( mysql_query("decide on count extensive type(*) FROM comments_table") ) ) you may run the question "decide on * FROM comments_table" and count extensive type the rows it returns, although that is way less powerful with the aid of fact the database has to deliver each and all of the rows back.