mysql fields

chrisleon

If I have a table with 10 fields, and I want a simple way to check if all fields have some sort of data residing in it, how would I do that with out writing 10 different if else statements?

Drakla

Can you post the schema of the table, as it might be as simple as doing count(fieldname) - empty ones won't add to the count.

chrisleon

I am a little confused about what the schema is.

The table consist of

employee name
employee number
employee email address

One person fills in this information.

I want to run a quick select from the table and verify that all the fields have data inside.

If so, email that the form is complete

else, do nothing

Drakla

Ah, first of all I thought you meant 10 rows, so if you did

SELECT count(name), count(number), count(email) FROM table;

And they all weren't 10 then you knew the table had gaps in it - ok, then I think you want something like this

$emptyFields = 0;

$q = "SELECT * FROM table";
$res = mysql_query($q);

while ($row = mysql_fetch_row($res) )
{		// check each field in the row to see if it's empty
	foreach ($row as $value)
	{
		if ($value === '')	// assuming you're just looking for empty strings and zeroes are ok
		{
			$emptyFields++;
		}
	}
}

if ($emptyFields == 0)
{
	// do your email saying good things abound
}
else
{
	echo 'Oh dear, there are ', $emptyFields, ' fields not filled in';
}

liquorvicar

why not get your query to do the work?

$sql = "select * from table where field1='' or field2='' or field3=''";
$query = mysql_query($sql,$c);
$result = mysql_fetch_array($query);
if ($result==0) {
//send email saying form is complete
}

you may need to make all your fields NOT NULL for this to work.