Hi guys! Need help in PHP plsss? ^_^

[SolidScript]

Hi guys! I'm just new to PHP, and I am really having a hard time with it. Could you please help me? ^^ I'm suppose to create a page that will tally all the inputted fields in a table. Each inputted field is equivalent to "1" and each empty field is equivalent to "0". If a field isn't empty then all inputted fields should be sum up. Here's my code...

$VesselApproached = $row['VesselApproached'];

if (empty($VesselApproached))
{
$VesselApproached = 0;
}
else
{
$VesselApproached = 1;
}

if ($VesselApproached = 1)
{
$query_1a = "SELECT SUM(VesselApproached) FROM i_questionnaire_1a";

$result = mysql_fetch_array($query_1a);
{
echo "$VesselApproached";
}
}

I really don't know where to start here. I just searched codes from the internet to help me out.. The problem is... its still not working... Ouch!

[mlseim]

There's a difference between blank (empty) and NULL.
When a table is created, you may or may not have specified that a column can ever be NULL.
Or, you may have entered ' ' or '' as a value (space or empty).

Try both of these queries to see what the result is ...

PHP Code:


<?php

$query_1a = "SELECT VesselApproached FROM i_questionnaire_1a WHERE VesselApproached IS NOT NULL";
$result = mysql_fetch_array($query_1a); 
$num_rows = mysql_num_rows($result);
echo "There are $num_rows that are NOT NULL";

$query_1a = "SELECT VesselApproached FROM i_questionnaire_1a WHERE VesselApproached IS NOT EMPTY";
$result = mysql_fetch_array($query_1a); 
$num_rows = mysql_num_rows($result);
echo "There are $num_rows that are NOT EMPTY";
?>

[SolidScript]

Both are working, but the $num_rows isn't showing. It only says, "There are "__________" that are NOT EMPTY/NULL"..

[Fou-Lu]

Methinks you'll need an mysql_query in there somewhere

[mlseim]

doh! I didn't even notice that.

PHP Code:



<?php 

$query_1a = mysql_query("SELECT VesselApproached FROM i_questionnaire_1a WHERE VesselApproached IS NOT NULL"); 
$result = mysql_fetch_array($query_1a);  
$num_rows = mysql_num_rows($query_1a); 
echo "There are $num_rows that are NOT NULL"; 

$query_2a = mysql_query("SELECT VesselApproached FROM i_questionnaire_1a WHERE VesselApproached IS NOT EMPTY"); 
$result2 = mysql_fetch_array($query_2a);  
$num_rows = mysql_num_rows($query_2a); 
echo "There are $num_rows that are NOT EMPTY"; 
?>

.

[SolidScript]

The "NOT NULL" query is working. The "NOT EMPTY" isn't..

[SolidScript]

Wow! That worked! Thanks sooo much! Now I'll be working on the over all percentage of the field. Thanks for helping!