How to count table Horizontal in mysql database?
<p>I have a table with 15 Columns <code>ID</code>, <code>USERNAME</code>, <code>PASSWORD</code>, <code>EMAIL</code>, <code>TELEPHONE</code>, <code>FAX</code>, <code>ADDRESS</code>, <code>COUNTRY</code>, <code>CITY</code>, <code>NATIONALITY</code>, <code>EDUCATION</code>, etc in mysql database.</p>

<p>There is some required fields and optional fields. Users will fill the required fields and some optional fields. I need to give every user <em>completeness score</em> (e.g. <code>Completeness Score 40%</code>) to increase there attention to fill all optional fields. </p>

<p>How can I do that in PHP? I've tried to do it by ( SELECT COUNT WHERE ) - but without any result.</p>
