<div style="margin-left:10%;margin-top:40px;"><!-- [et_pb_line_break_holder] --><h2>Scholarships and Awards</h2><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- TEMPLATE ENDS, START QUERY FORM --><!-- [et_pb_line_break_holder] --><noscript><!-- [et_pb_line_break_holder] --><h3>Your browser does not support JavaScript. Please allow JavaScript in order to use the search window.</h3></noscript><!-- [et_pb_line_break_holder] --><?php <!-- [et_pb_line_break_holder] -->$username="nppfawards";<!-- [et_pb_line_break_holder] -->$password = 'L#6k7P1KH@Ib';<!-- [et_pb_line_break_holder] -->$database="nppfawards";<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->mysql_connect('p3nld41mysql3.secureserver.net',$username,$password);<!-- [et_pb_line_break_holder] -->@mysql_select_db($database) or die( "Unable to select database");<!-- [et_pb_line_break_holder] -->$query="select a.Fname, a.Mname, a.Lname, a.Organization, a.Year, name.award_name, name.award_name_short, name.award_description, name.award_status, name.award_sort from awards as a <!-- [et_pb_line_break_holder] -->INNER JOIN award_name as name ON a.Award = name.idaward_name ORDER BY name.award_sort ASC, a.Year DESC";<!-- [et_pb_line_break_holder] -->$result=mysql_query($query);<!-- [et_pb_line_break_holder] -->$num=mysql_numrows($result);<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->$query2="SELECT Fname FROM awards where Fname=\"no workshop\" or Fname=\"None\" or Fname=\"None listed\" or Fname=\"not awarded\" or Fname=\"none\"";<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->$result2=mysql_query($query2);<!-- [et_pb_line_break_holder] -->$minusnum=mysql_numrows($result2);<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->$Count=$num-$minusnum;<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->mysql_close();<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->echo"<br /><br />\r\n";<!-- [et_pb_line_break_holder] -->echo"<label for='search_field'>Enter a term to search (Scholarship Name, Organization, Name or Year):</label><br />";<!-- [et_pb_line_break_holder] -->echo"<br />\r\n";<!-- [et_pb_line_break_holder] -->echo"<input id='search_field' name='search_field' type='text'/>";<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->echo "<div >The National Press Photographers Foundation has provided $Count scholarships and awards for students and professionals in support of furthering their education. <a href=\"http:\/\/nppf.org\/donations\">Please consider supporting the NPPF</a> through your charitable and tax deductible contributions. The NPPF is the foundation for photojournalism.</div>";<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->for( $i = 0; $i < $num; $i++ ) {<!-- [et_pb_line_break_holder] --> $Fname=mysql_result($result,$i,"a.Fname");<!-- [et_pb_line_break_holder] --> $Mname=mysql_result($result,$i,"a.mname");<!-- [et_pb_line_break_holder] --> $Lname=mysql_result($result,$i,"a.Lname");<!-- [et_pb_line_break_holder] --> if ($Mname != "") {<!-- [et_pb_line_break_holder] --> $Name=$Fname." ".$Mname." ".$Lname;<!-- [et_pb_line_break_holder] --> } else {<!-- [et_pb_line_break_holder] --> $Name=$Fname." ".$Lname;<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --> $Organization=mysql_result($result,$i,"a.Organization");<!-- [et_pb_line_break_holder] --> $Award=mysql_result($result,$i,"name.award_name");<!-- [et_pb_line_break_holder] --> $AwardShort=mysql_result($result,$i,"name.award_name_short");<!-- [et_pb_line_break_holder] --> $Year=mysql_result($result,$i,"a.Year");<!-- [et_pb_line_break_holder] --> $Description=mysql_result($result,$i,"name.award_description");<!-- [et_pb_line_break_holder] --> $Status=mysql_result($result,$i,"name.award_status");<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> <!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->echo "<div class=\"option\">";<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> if ($ChangeName != $Award) {<!-- [et_pb_line_break_holder] --> echo "<div class=\"award\">$Award</div>"; <!-- [et_pb_line_break_holder] --> echo "<div class=\"description\">$Description</div>";<!-- [et_pb_line_break_holder] --> echo "<div class=\"status\">Qualifying status: $Status<br /><br /></div>";<!-- [et_pb_line_break_holder] --> echo "<div class=\"name fltlft\">$Name</div> <div class=\"year fltlft\">$Year</div><div class=\"awardshort fltlft\">$AwardShort</div> <div class=\"organization fltlft\">$Organization</div> " ;<!-- [et_pb_line_break_holder] --> echo"<div class=\"clearfloat\"></div>";<!-- [et_pb_line_break_holder] --> $ChangeName=$Award;<!-- [et_pb_line_break_holder] --> } else {<!-- [et_pb_line_break_holder] --> echo "<div class=\"name fltlft\">$Name</div> <div class=\"year fltlft\">$Year</div><div class=\"awardshort fltlft\">$AwardShort</div> <div class=\"organization fltlft\">$Organization</div> " ;<!-- [et_pb_line_break_holder] --> echo"<div class=\"clearfloat\"></div>";<!-- [et_pb_line_break_holder] --> $ChangeName=$Award;<!-- [et_pb_line_break_holder] --> <!-- [et_pb_line_break_holder] --> <!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->echo"</div>";<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->?><!-- [et_pb_line_break_holder] --></div><!-- [et_pb_line_break_holder] -->