Is it possible to Query a Mysql database from a field selected from dropdown menu populated from a Query in php

manpreet Best Answer 2 years ago

Hello i am new to php and i have tried to find a piece of code that i can use to complete the task i need, i currently have a page with a form set out to view the criteria of a course. also i have a dropdown menu which currently holds all the course codes for the modules i have stored in a database. my problem is when i select a course code i wish to populate the fields in my form to show all the information about the course selected. The code i am trying to get to work is as follows:

php 
session_start();
?>
 include ("dbcon.php") ?>
php

if(!isset($_GET['coursecode'])){ 
$Var ='%'; 
} 
else 
{ 
if($_GET['coursecode'] == "ALL"){ 
$Var = '%'; 
} else { 
$Var = $_GET['coursecode']; 
} 
}


echo "
 
Coursecode
";

$res=mysql_query("SELECT * FROM module GROUP BY mId"); 
if(mysql_num_rows($res)==0){ 
echo "there is no data in table.."; 
} else 
{ 
echo "id=\"coursecode\"> ALL "; 
for($i=0;$i<mysql_num_rows($res);$i++) 
{ 
$row=mysql_fetch_assoc($res); 
echo";

if($Var==$row[coursecode]) 
echo " selected"; 
echo ">$row[coursecode]"; 
}
echo ""; 
}
echo "
 


";

$query = "SELECT * FROM module WHERE coursecode LIKE '$Var' "; 
$result = mysql_query($query) or die("Error: " . mysql_error());

if(mysql_num_rows($result) == 0){ 
echo("No modules match your currently selected coursecode. Please try another coursecode!"); 
} ELSE { 
        Coursecode: echo $row['coursecode'];
        Module: echo $row['mName']; 
        echo $row['mCredits'];
        echo $row['TotalContactHours'];
        echo $row['mdescription'];
        echo $row['Syllabus'];
        }
?>

however i can only seem to get the last entry from my database any help to fix this problem or a better way of coding this so it works would be grateful

Thanks

manpreet 2 years ago

$result = mysql_query(...) or die(mysql_error());
while($row = mysql_fetch_assoc($result)) {
   ...
}