Basic question - hopefully!

[siblood]

Hi. I am new to PHP. I want to create a basic form that will allow a user to enter a "Student ID". I then want to search the database "students" and retrieve records based on this value into a new page. It seems so simple, but once I have seen how this is done, I am sure I will get into how PHP does things. Can anyone help? It will be greatly appreciated!

 

Kind regards,

 

Simon.

[DeanWhitehouse]

<?php
if(isset($_POST['submit']))
{
$id = mysql_real_escape_string($_POST['id']);
$row = mysql_fetch_assoc(mysql_query("SELECT * FROM database WHERE studentid = '{$id}'"));
echo $row['details'];
exit();
}
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
Student id:<input type="text" name="id"/>
<input type="submit" name="submit" value="Go!"/>
</form>

simple , and needs tweaking to ure db