Search the Community

Hello friends, I am working on php to improve my web development skills. I have created a web based university system using php and mysql. However, I got stuck in coding multi variables to query mysql using php. The multi variables are placed in mysql_query() with AND operator as shown below. $query3= mysql_query("SELECT * FROM Student WHERE Student_Name='$xstudent' AND Intake='$xmenu'"); I could be able to query single variable however, face problems with multiple variables. The codes below works but when I query $xboth the output displays three tables showing $query, $query2 and $query3. I WANT TO DISPLAY ONLY $QUERY3 when passing $xboth. <?php include 'Lecture/connection.php'; $xstudent=$_POST['stuname']; $xmenu=$_POST['drop']; $xboth= $_POST['stuname'] AND $_POST['drop']; $query= mysql_query("SELECT * FROM Student WHERE Student_Name='$xstudent'"); $query2= mysql_query("SELECT * FROM Student WHERE Intake='$xmenu'"); $query3= mysql_query("SELECT * FROM Student WHERE Student_Name='$xstudent' AND Intake='$xmenu'"); if($xstudent) { $fields_num = mysql_num_fields($query); // Display table echo "<table border='1'><tr>"; for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($query); echo "<td>{$field->name}</td>"; } echo "</tr>\n"; while($row = mysql_fetch_row($query)) { echo "<tr >"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell) echo "<td width= '30' >$cell</td>"; echo "</tr>\n"; } } if($xmenu) { $fields_num2 = mysql_num_fields($query2); // Display table echo "<table border='1'><tr>"; for($i=0; $i<$fields_num2; $i++) { $field2 = mysql_fetch_field($query2); echo "<td>{$field2->name}</td>"; } echo "</tr>\n"; while($row2 = mysql_fetch_row($query2)) { echo "<tr >"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row2 as $cell2) echo "<td width= '30' >$cell2</td>"; echo "</tr>\n"; } } if($xboth ) { $fields_num3 = mysql_num_fields($query3); // Display table echo "<table border='1'><tr>"; for($i=0; $i<$fields_num3; $i++) { $field3 = mysql_fetch_field($query3); echo "<td>{$field3->name}</td>"; } echo "</tr>\n"; while($row3 = mysql_fetch_row($query3)) { echo "<tr >"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row3 as $cell3) echo "<td width= '30' >$cell3</td>"; echo "</tr>\n"; } } Please click below to check the screenshot of the output. http://farazi14.webs.com/query.jpg http://farazi14.webs.com/query2.jpg http://farazi14.webs.com/query3.jpg THANKS GUYS