[turnbuk]

I have a database with a moderate number of facilities and their respective information i.e. facilty number, address, operatinn hours. I'd like to create a simple search form webpage that would allow me to type in the facility number and that facility and information would appear right below where i inputted the search parameters, and nothing else. Anybody have any suggestions on how i could get this started? Thanks.

[Mr.LLB]

If you are familiar with php, then this is quite easy.

look at this:

$search = mysqlquery("SELECT * FROM TABLE WHERE FACILITY_NUMBER LIKE '%$facility_number%'");

this would give you results of identical facility numbers based on what you feed the $facility_number variable.

if you want me to do the entire script then please post again

[turnbuk]

I'm not familiar with PHP so if its not too much trouble I'd appreciate it if you could write the script.

[Mr.LLB]

THE FORM:

<!-- This is where you enter the facility number which you want to search --> <form method='POST' action='search_results.php'> <input type='text' name='search' size='40' > <input type='submit' value='Search'> </form> 

THE PHP CODE....FILE NAME......search_results.php

PHP Code:

<?php
$f_num = $_POST['search'];
//enter your database information
$db_connection = mysql_connect("HOST NAME","USERNAME","PASSWORD");
mysql_select_db("DATABASE NAME THAT YOUR INFORMATION IS IN", $db_connection);
$results = mysql_query("SELECT * FROM YOUR_TABLE_NAME WHERE FACILITY_NUMBER LIKE '%$f_num%' ");
while($row=mysql_fetch_array($results)) {
 
 echo $row['THE INFORMATION YOU WANT TO RETRIVE BASED ON YOUR FACILITY NUMBER'];
 
}
?>

[Mr.LLB]

youll have to change some values as for host name, password, username, database name...etc.

YOUR_TABLE_NAME WHERE FACILITY_NUMBER LIKE = the column in which you have stored your facility numbers in the database.