RESULTS FOR 2011 Please enter a search string.\n ");
/* echo( "
";
}
function bold_it($i,$name) {
$i=eregi_replace( "$name", "$name",$i);
$i=strtoupper($i);
$i=stripslashes($i);
return($i);
}
function search_it($name, $name2) {
include( "../mystuff.wphp");
global $offset,$total,$lpp,$dir,$chapter;
/* connect to the database */
mysql_connect( "$hostname", "$username", "$password");
@mysql_select_db( "$dbName") or die( "Unable to select database");
/* search tables - note the flagrant use of the contain-like searching... */
/*$query = "SELECT csiMumbai.code, csiMumbai.typecode, csiMumbai.gradecode, csiMumbai.Title,
csiMumbai.name, csiMumbai.joindate, csiMumbai.desig, csiMumbai.add1, csiMumbai.add2, csiMumbai.add3,
csiMumbai.city, csiMumbai.pin, csiMumbai.state, csiMumbai.state, csiMumbai.chapname,
csiMumbai.telephone, csiMumbai.fax, csiMumbai.email, csiMumbai.off_name, csiMumbai.off_add1,
csiMumbai.off_add2, csiMumbai.off_ctname, csiMumbai.off_pin, csiMumbai.off_ph, csiMumbai.off_fax,
csiMumbai.paystatus, csiMumbai.holdmail, csiMumbai.exprdate, csiMumbai.lifedate, csiMumbai.recptno,
csiMumbai.recptdate, csiMumbai.rcptamt, csiMumbai.password FROM csiMumbai AS csiMumbai WHERE
csiMumbai.code LIKE '%$name%' AND csiMumbai.password LIKE '%$name2%'";
*/
$chapter = $name2 ;
$query = "SELECT $chapter.Seat_No, $chapter.Marks, $chapter.Remarks FROM $chapter AS $chapter WHERE $chapter.Seat_No LIKE '$name' ";
$result = mysql_query($query);
@$total= mysql_numrows($result);
if ($total== 0) {
print "Sorry, either you have enter wrong roll no. or selected a wrong faculty or no such requested characteristics have been found within the database. "; /*echo mysql_error();*/
}
elseif ($total> 0) {
PRINT "
Your Result for Roll No. $name is as follow :
";
/* default */
$counter=0;
while (list($TrainNo, $Departure) = MySQL_Fetch_Array($result)){
while ($counter < $num) {
$j=0;
$j=$counter + 1;
}
if ($name2== 'BScIT_II') {
$faculty = "First Year BSc IT Semester II";
}
elseif ($name2== 'BScIT_IV') {
$faculty = "Second Year BSc IT Semester IV";
}
elseif ($name2== 'XI_Arts') {
$faculty = "First Year Junior College Arts";
}
elseif ($name2== 'XI_Sci') {
$faculty = "First Year Junior College Science";
}
elseif ($name2== 'XI_Commerce') {
$faculty = "First Year Junior College Commerce";
}
elseif ($name2== 'FYBSC') {
$faculty = "First Year BSc";
}
elseif ($name2== 'FYBCOM') {
$faculty = "First Year BCom";
}
elseif ($name2== 'FYBA') {
$faculty = "First Year BA";
}
elseif ($name2== 'SYBA') {
$faculty = "Second Year BA";
}
elseif ($name2== 'SYBSC') {
$faculty = "Second Year BCom";
}
elseif ($name2== 'SYBCOM') {
$faculty = "Second Year BCom";
}
/*$chapter= 'csiMumbai';
*/
$p=mysql_result($result,$counter,"Seat_No");
$i=mysql_result($result,$counter,"$chapter.Seat_No");
$tc = mysql_result($result,$counter,"$chapter.Marks");
$gc = mysql_result($result,$counter,"$chapter.Remarks");
$fare = $Km2 - $Km1;
echo ("");
}
?>