retrieve mysql data

Answer 1

You need to search from your present tables and use AJAX to notify the user.

I would suggest you look into a framework in PHP which would help you a LOT since you are just starting your projects. List of frameworks can be found at http://www.phpframeworks.com/

Answer 2

As a suggestion, I do not think displaying the values inside of a textbox is the best idea. With that being said, you achieve your results by performing the following

while($row = mysql_fetch_array($result)) {
 echo "<input type=\"text\" value='" . $row['HOSPNUM'] . "'><br />";
 echo "<input type=\"text\" value='" . $row['ROOMNUM'] . "'><br />";
 ....
}

You would need to escape the " inside of the text boxes by using PHP's escape special character \

Answer 3

As far as i could understand your question, you want to retrieve data from mysql based on the input of the text boxes. This is how you can go about it:

<form action="yourpage.php">
  <input type="text" name="text1">
  <input type="text" name="text2">
  <input type="text" name="text3">
</form>

Now you can retrieve data from mysql using where clause.

select * from table where text1 = 'text1' and  text2 = 'text2' and  text3 = 'text3'

Note: You need to change the names in form and query as per your requirement.