[MLUG] Re: count fields

[EMAIL:PROTECTED]

> I want to count No. of filled fields in any row
> i am seeking a query that returns me the number of filled fields in a row;
> any one can help me

You're going to want to pass a MySQL query to your database and table:

$your_sql_variable "SELECT * FROM $your_database";

Hold the result in a variable:

$your_result = mysql_query($your_sql_variable, $connection) or die(mysql_error());

Then count the number of rows returned by $your_result:

$number_of_rows = mysql_num_rows($your_result);

If this doesn't help you out, feel free to e-mail me off of the list at this e-mail address.

Cheers,

Matt

--PREMIERE - 3 Monate gratis sehen Digitalreciver ab 1? - ab 16ct pro Taghttp://shopping.freenet.de/specials/premiere/index.html?partner_id=free6

_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members