[bookemdanno]

Hi I'm new, excuse me if i sound stupid, but i am being asked to produce a capability search for a website. I am a designer, not a programmer, therefore I Know nothing of this, and i'm trying to accomplish what has been thrown at me.

With Php been used more widely would Php and MySQL be best to produce this search or should i use others?

The Part number needs to be entered into the search, which if correct will display the: part no./description/price

If the number doesn't exist, then an out of stock text needs to appear.

Any help, or advice would be greatly appreciated.

[greybird]

Assuming that you have a database with all the part numbers entered into it then it is a very easy task, you just need to connect to the database and then send a query to look for that part number:

PHP Code:

$db = mysql_connect('localhost', 'user', 'password');

mysql_select_db('database_name', $db);



//we have used a form to submit the data using the POST method

$part_num = (int)$_POST['part_number']; //makes sure its an int

$result = mysql_query("SELECT * FROM parts WHERE number = '$part_num'");

if(mysql_num_rows($result)){

   //display results

}else{

   //show error message - no results found

} 

If the part numbers arent already in the database then it might be slightly harder to do.

Hope that helps.

[bookemdanno]

Thanks for the reply.

The database fields are below.

Part Number / Description / Manufacturer / End Unit P/N

1326917 / Field Assy / Bendix / 30E02

1531445 / Main Stator Assy / Allied Signal / 28B141

Thanks for your help, hopefully i'll be on the right track. I just had this thrown at me, and i'm expected to have it done asap. Bosses who just don't understand things.