如何计算具有特定行名称的填充行 - 我的sql

Question

What I want to do is count all my filled rows of specific row name I select, let me give you an example:

Its like I have a table with 6 columns; the very first column is email - and the rest column are slot1, slot2, slot3, slot4, slot5.

Now what I want to have is a function that - when I select a specific email address - it returns how many slots are filled under that email address - just like when we use this command:

$t = select * from tabnlename where email=something 
mysql_fetch_array($t)
echo $t['slot1'] . $t['slot1'] and on and on ...

I want a function that counts how many slots are filled where email = mychoiceemail.

Let me give you some more details take a look at my sql table

supemail           slot1          slot2         slot3           slot4         slot5
[e-mail]   somedata       somedata       somedata        somedata       somedata
[e-mail]     somedata                    somedata         somedata
[e-mail]                  somedata

now what i want is when i select [e-mail] the function should return 5 as it has all 5 columns filled ! when i select [e-mail] it should return 3 as it has 3 slots filled and when i select [e-mail] it should return 1 only as it has only 1 slot filled !

Answer 1

Have a look at mysqli_query, there are plenty of examples there.

Your query could look something like:

select Count(*)
from MyTable
where email = $something