No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
[CODE] <select name="year"> <option value="2010">2010</option> <option value="2011">2011</option> <option value="2012">2012</option> <option value="2013">2013</option> </select> <input type="submit" name="sub" value="Search"/> </div> <?php if(isset($_REQUEST['sub'])){ $year=$_REQUEST['year']; $con=mysql_connect("localhost","root","")or die( "Unable to connect"); mysql_select_db("mydb",$con) or die( "Unable to select database"); $query="SELECT * FROM student WHERE EnrolledYear='$year'"; $result=mysql_query($query)or die(mysql_error());; $num=mysql_numrows($result); mysql_close(); ?> <table> <tr> <th>Student ID No.</font></th> <th>Name</font></th> <th>Enrolled …
|