<html>
<head>
<title>Search Questions</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
$query = '';
$query2 = '';
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm=trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'You haven\'t entered search details. Please try again';
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
@ $db = mysql_pconnect('localhost', 'root', '');
if (!$db)
{
echo 'Error: Cannot connect to database. ;p';
exit;
}
mysql_select_db('sistem bank soalan');
$query = "select * from soalan where ".$searchtype." like '%".$searchterm."%'" ;
$query2 = "select * from jawapan where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);
$result2 = mysql_query($query2);
//i'm trying to call both table using this statement. i know it was wrong but i just don't know how to solve this problem.
$num_results = mysql_num_rows($result && $result2);
echo '<p>Number of question found: '.$num_results.'</p>';
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
//from table soalan
echo '<p><strong>'.($i+1).'. No Soalan: ';
echo htmlspecialchars(stripslashes($row['id']));
echo'</strong><br />Soalan: ';
echo stripslashes($row['soalan']);
echo '<br />A: ';
//from table jawapan
echo stripslashes($row['jwpA']);
echo '<br />B: ';
echo stripslashes($row['jwpB']);
echo '<br />C: ';
echo stripslashes($row['jwpC']);
echo '<br />D: ';
echo stripslashes($row['jwpD']);
echo '<br />Jawapan: ';
echo stripslashes($row['jwpObj']);
//from table soalan
echo '<br />Aras Kesukaran: ';
echo stripslashes($row['araskesukaran']);
echo '<br />Sesi Peperiksaan: ';
echo stripslashes($row['sesipeperiksaan']);
echo '<br />Bahagian: ';
echo stripslashes($row['bahagian']);
echo '<br />Add User: ';
echo stripslashes($row['adduser']);
echo '</p>';
}
?>
<p align="center"><font face="BatangChe"><strong> </strong></font></p>
</body>
</html>
NOTES: i've two tables in this database which are table
QUESTION and
ANSWER. the
primary key of both tables are the same; which is
id. but i can't combine both tables because of some reason. so when i'm doing the seach process; i mean search engine for my system; i found a problem where i can't call both table at the same time to display the content. Refering to the same primary key;
id; i want to call both table to get their content. Anyone could help me with this?
9
