mysql_count_rows Function

mysql_count_rows - Return number of rows of MySQL Table.

Syntax

string mysql_count_rows ( string table_name, array condition)

Parameter

table_name

Name of the table where data is needed to be inserted.

Input Example: "table_name"

condition

Condition that you want to be:

Input Example: $condition["field_name"]["eq"] = "name";

Which means delete rows whose value of field is equal to string name i.e field_name = "name"

Other functions for conditions where eq can be replaced with:

eq - Equivalent to =

neq - Equivalent to !=

gr - Equivalent to >

sm - Equivalent to <

gre - Equivalent to >=

sme - Equivalent to <=

li - Equivalent to LIKE

nli - Equivalent to NOT LIKE

lip - Equivalent to %LIKE%

libp - Equivalent to %LIKE

liap - Equivalent to LIKE%

nlip - Equivalent to NOT %LIKE%

nlibp - Equivalent to NOT%LIKE

nliap - Equivalent to NOT LIKE%

regex - Equivalent to REGEXP

nregex - Equivalent to NOT REGEXP

in - Equivalent to IN

nin - Equivalent to NOT IN

Error	Description
Error: No table ("table_name") or field ("field_name") exists.	Field entered in condition or update_items either does not exist or table_name entered does not exists.

<?php

include("class.php");

$condition["field_name"]["eq"] = "Some Value";

echo mysql_count_rows("tablename" ,$condition);

Number of rows would be returned.