so basically, have php webpage using sql check if id selected. if not, auto selects results date 2015. 1st result missing. reading other posts, can assume select $result starting @ 1, though data in table starts @ 0. either that, or somehow part of code eating first result. assistance appreciated.
if (isset($_get["id"])){$id=$_get["id"];}else{$id="";} if ($id==""){ $select ="select * organicgrants lastupdated > '2015'"; $result = mysql_query($select); if (!$result) { echo("<p>error performing query: " . mysql_error() . "</p>"); exit(); } while ( $row = mysql_fetch_array($result) ) { $organicgrantsid=$row["organicgrantsid"]; $firstname=$row["teacherfirstname"]; $lastname=$row["teacherlastname"]; $lastupdated=date('f j, y', strtotime($row["lastupdated"])); echo ("<p>"); echo("<p><b>total applications displayed: ".mysql_num_rows($result)."</b></p>"); echo ("<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\">"); echo ("<tr bgcolor=\"#cccccc\"><td><strong>teacher name</td><td><strong>school name</td><td><strong>state</td><td><strong>grade(s)</td><td><strong>submitted date</td> <td><strong>status</td></strong></tr>"); while ( $row = mysql_fetch_array($result) ) {; $organicgrantsid=$row["organicgrantsid"]; $teacherfirstname=$row["teacherfirstname"]; $teacherlastname=$row["teacherlastname"]; $schoolname=$row["schoolname"]; $schoolstate=$row["schoolstate"]; $gradelevels=$row["gradelevels"]; $lastupdated=$row["lastupdated"]; $grantstatus=$row["grantstatus"]; //$staffawarded=$row["staffawarded"]; //$staffconference=$row["staffconference"]; switch ($grantstatus){ case "": $grantstatus="waiting list"; break; case "0": $grantstatus="waiting list"; break; case "1": $grantstatus="awarded"; break; case "2": $grantstatus="not awarded"; break; } $lastupdated=date('f j, y', strtotime($row["lastupdated"])); echo ("<tr><td><a href=\"results.php?id=".$organicgrantsid."\">".$teacherfirstname." ".$teacherlastname."</a></td><td>".$schoolname."</td><td>".$schoolstate."</td><td>".$gradelevels."</td><td>(".$lastupdated.")</td><td>".$grantstatus."</td></tr>"); } echo ("</table>"); } }else{ $select ="select * organicgrants organicgrantsid=$id"; $result = mysql_query($select); if (!$result) { echo("<p>error performing query: " . mysql_error() . "</p>"); exit(); } while ( $row = mysql_fetch_array($result) ) { $schoolname=$row["schoolname"]; $schooladdress=$row["schooladdress"]; $schoolcity=$row["schoolcity"]; $schoolstate=$row["schoolstate"]; $schoolzip=$row["schoolzip"]; $schoolphone=$row["schoolphone"]; $schoolcounty=$row["schoolcounty"]; $gradelevelsitem=$row["gradelevels"]; $teacherfirstname=$row["teacherfirstname"]; $teacherlastname=$row["teacherlastname"]; $teacherposition=$row["teacherposition"]; $teacheremail=$row["teacheremail"]; $teacherphone=$row["teacherphone"]; $numberofstudents=$row["numberofstudents"]; $budgeta=$row["budgeta"]; $budgetb=$row["budgetb"]; $budgetc=$row["budgetc"]; $budgetd=$row["budgetd"]; $budgete=$row["budgete"]; $budgetf=$row["budgetf"]; $budgetg=$row["budgetg"]; $budgeti=$row["budgeti"]; $budgetj=$row["budgetj"]; $budgetk=$row["budgetk"]; $budgetaamt=$row["budgetaamt"]; $budgetbamt=$row["budgetbamt"]; $budgetcamt=$row["budgetcamt"]; $budgetdamt=$row["budgetdamt"]; $budgeteamt=$row["budgeteamt"]; $budgetfamt=$row["budgetfamt"]; $budgetgamt=$row["budgetgamt"]; $budgethamt=$row["budgethamt"]; $budgetiamt=$row["budgetiamt"]; $budgetjamt=$row["budgetjamt"]; $budgetkamt=$row["budgetkamt"]; $budgetlamt=$row["budgetlamt"]; $budgetmamt=$row["budgetmamt"]; $essayimportant=$row["essayimportant"]; $essaybenefit=$row["essaybenefit"]; $essayexperience=$row["essayexperience"]; $essaybeneficial=$row["essaybeneficial"]; $supportingfunds=$row["supportingfunds"]; $principalname=$row["principalname"]; $principalemail=$row["principalemail"]; $grantstatus=$row["grantstatus"]; $w9status=$row["w9status"]; $agreementstatus=$row["agreementstatus"]; $progressstatus=$row["progressstatus"]; $finalstatus=$row["finalstatus"]; $receiptsstatus=$row["receiptsstatus"]; $staffstatus=$row["staffstatus"]; $imisstatus=$row["imisstatus"]; $schooladmin=$row["schooladmin"]; if ($schooladmin==1){$schooladmin="yes";}else{$schooladmin="no";} $w9form=$row["w9form"]; if ($w9form==1){$w9form="yes";}else{$w9form="no";} $gradelevelsitem=""; if (isset($_post['gradelevels'])==true){$gradelevels=$_post['gradelevels'];foreach ($gradelevels $key => $value )$gradelevelsitem.="$value, ";} $gradelevelsitem=substr($gradelevelsitem,0,(strlen($gradelevelsitem)-2));`
what purpose of 2 while loops (except of stealing first row – in inner loop reassign value of $row variable outer loop's first iteration)? move assignments/output in first while loop remove second (you missing curly brackets {} guess inner loop).
instead of :
while ( $row = mysql_fetch_array($result) ) { $organicgrantsid=$row["organicgrantsid"]; $firstname=$row["teacherfirstname"]; $lastname=$row["teacherlastname"]; $lastupdated=date('f j, y', strtotime($row["lastupdated"])); echo ("<p>"); echo("<p><b>total applications displayed: ".mysql_num_rows($result)."</b></p>"); echo ("<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\">"); echo ("<tr bgcolor=\"#cccccc\"><td><strong>teacher name</td><td><strong>school name</td><td><strong>state</td><td><strong>grade(s)</td><td><strong>submitted date</td><td><strong>status</td></strong></tr>"); while ( $row = mysql_fetch_array($result) ) {; $organicgrantsid=$row["organicgrantsid"]; $teacherfirstname=$row["teacherfirstname"]; $teacherlastname=$row["teacherlastname"]; $schoolname=$row["schoolname"]; $schoolstate=$row["schoolstate"]; $gradelevels=$row["gradelevels"]; $lastupdated=$row["lastupdated"]; $grantstatus=$row["grantstatus"]; //$staffawarded=$row["staffawarded"]; //$staffconference=$row["staffconference"]; switch ($grantstatus){ case "": $grantstatus="waiting list"; break; case "0": $grantstatus="waiting list"; break; case "1": $grantstatus="awarded"; break; case "2": $grantstatus="not awarded"; break; } $lastupdated=date('f j, y', strtotime($row["lastupdated"])); echo ("<tr><td><a href=\"results.php?id=".$organicgrantsid."\">".$teacherfirstname." ".$teacherlastname."</a></td><td>".$schoolname."</td><td>".$schoolstate."</td><td>".$gradelevels."</td><td>(".$lastupdated.")</td><td>".$grantstatus."</td></tr>"); } echo ("</table>"); } use :
echo ("<p>"); echo("<p><b>total applications displayed: ".mysql_num_rows($result)."</b></p>"); echo ("<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\">"); echo ("<tr bgcolor=\"#cccccc\"><td><strong>teacher name</td><td><strong>school name</td><td><strong>state</td><td><strong>grade(s)</td><td><strong>submitted date</td><td><strong>status</td></strong></tr>"); while ( $row = mysql_fetch_array($result) ) { $organicgrantsid=$row["organicgrantsid"]; $firstname=$row["teacherfirstname"]; $lastname=$row["teacherlastname"]; $lastupdated=date('f j, y', strtotime($row["lastupdated"])); $organicgrantsid=$row["organicgrantsid"]; $teacherfirstname=$row["teacherfirstname"]; $teacherlastname=$row["teacherlastname"]; $schoolname=$row["schoolname"]; $schoolstate=$row["schoolstate"]; $gradelevels=$row["gradelevels"]; $lastupdated=$row["lastupdated"]; $grantstatus=$row["grantstatus"]; //$staffawarded=$row["staffawarded"]; //$staffconference=$row["staffconference"]; switch ($grantstatus){ case "": $grantstatus="waiting list"; break; case "0": $grantstatus="waiting list"; break; case "1": $grantstatus="awarded"; break; case "2": $grantstatus="not awarded"; break; } $lastupdated=date('f j, y', strtotime($row["lastupdated"])); echo ("<tr><td><a href=\"results.php?id=".$organicgrantsid."\">".$teacherfirstname." ".$teacherlastname."</a></td><td>".$schoolname."</td><td>".$schoolstate."</td><td>".$gradelevels."</td><td>(".$lastupdated.")</td><td>".$grantstatus."</td></tr>"); } echo ("</table>"); 