I am new to php…
following is the code which should give result from database, but it is not showing it.
<tr>
<td> Student ID: <label id=”Stud_ID1″ for=”ID”></label></td>
<?php echo $_POST[‘Stud_ID’];?>
<?php
define (‘DB_HOST’,’204.158.158.29′); // Host name
define(‘DB_USER’,’rakesh’); // Mysql username
define(‘DB_PASSWORD’,’ww23′); // Mysql password
define(‘DB_NAME’,’start’); // Database name
// Connect to server and select database.
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link)
{
die(“Could not connect”);
}
$db_selected = mysql_select_db(DB_NAME, $link);
if(!$db_selected)
{
die(“Can not use”.DB_NAME.’:’.mysql_err());
}
$query2 =mysql_query(“SELECT Stud_ID FROM Student WHERE Stud_ID =’$Stud_ID'”) or die(‘wrong query’.mysql_error());
?>
<td> <label id=”degree”>Degree</label></td>
</tr>
<tr>
<td> <label id=”name”> Student Name:</label></td>
<?php
$Stud_ID = $_POST[‘Stud_ID’];
$query2 =mysql_query(“SELECT Stud_Lastname, Stud_Firstname FROM Student WHERE Stud_ID =’$Stud_ID'”) or die(‘wrong query’.mysql_error());
while($row = mysql_fetch_array($query2,0))
{
echo $row[‘Stud_Lastname’] . ” ” . $row[‘Stud_Firstname’];
}
?>
<td><label id=”advior”>Advisor</label> </td>
</tr>