No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
<?php $SearchNo = $_POST["SearchNo"]; $host= 'localhost'; $user= 'zutransportation'; $passwd= 'password'; $database= 'dbtransport'; $table= 'STUDENT'; $table2='BUS'; $connect= mysql_connect($host, $user, $passwd); mysql_select_db($database); $squery = "select * from $table where IDNo like '".$SearchNo."'"; $run= mysql_query($squery); $num_results = mysql_num_rows($run); if (!$SearchType ) {//1 echo "You have not selected search details. Please go back and …
|
|
|
<?php $SearchType = $_POST["SearchPlace"]; $host= 'localhost'; $user= 'user'; $passwd= 'password'; $database= 'dbase'; $table1= 'BUS'; $table2= 'STUDENT'; $connect= mysql_connect($host, $user, $passwd); mysql_select_db($database); $pquery = "select busNo from $table1 where place like '".$SearchType."'"; $squery = "select * from $table2 where busNo like '".$pquery."'"; $run = mysql_query($squery); $num_results = mysql_num_rows($run); if (!$SearchType ) … 
|