สวัสดีครับ

 

ขอบคุณครับที่กรุณาแนะนำ อย่างไรก็ตามคิดว่าผมให้ข้อมูลน้อยเกินไป จึงต้องเสนอข้อมูลเพิ่มเติมดังนี้ครับ

 

ผมเขียนโปรแกรมขึ้นมาเพื่อเก็บข้อมูลชื่อ, ที่อยู่, email, ประเทศ, กลุ่มสินค้าอาหารที่ผลิต ของบริษัทต่างๆดังนี้

 

<br>

<script language="javascript" type="text/javascript">

function validate(obj){

    if(obj.product.value == "0"){

       alert("Please select product");

       obj.product.focus();

       return false;

    }else if(obj.country.value == "0"){

       alert("Please select country");

       obj.country.focus();

       return false;

    }

    return true;

}

</script>

 

<font color="#000000" face="verdana" size="1"><b>www.anan is a world food company directory. We have more than 20,000 food companies that you can open business gate to sell or buy food products.

<p>Post buy and sell member's food products will send to food company in our database that they agree to receive.</p>

<p>Cost of member is USD200/year. If you interest, please register at member register.</p></u></font>

<font color="#000000" face="verdana" size="1"><b><u>Food company search</u></b></font>

 

<table border="0" width="400">

<tr>

<td width="200"><font color="#8B4513" face="verdana" size="1"><b>Alphabetical search</b></td>

</tr>

<tr>

<td><form name="form2" method="post" action="index_search1.php">

<select name="alphabet">

<option value="0">Please select alphalet</option>

<option value="A">A</option>

<option value="B">B</option>

<option value="C">C</option>

<option value="D">D</option>

<option value="E">E</option>

<option value="F">F</option>

<option value="G">G</option>

<option value="H">H</option>

<option value="I">I</option>

<option value="J ">J</option>

<option value="K">K</option>

<option value="L">L</option>

<option value="M">M</option>

<option value="N">N</option>

<option value="O">O</option>

<option value="P">P</option>

<option value="Q">Q</option>

<option value="R">R</option>

<option value="S ">S</option>

<option value="T ">T</option>

<option value="U">U</option>

<option value="V">V</option>

<option value="W">W</option>

<option value="X">X</option>

<option value="Y">Y</option>

<option value="Z">Z</option>

</select></td>

<td width="100" colspan="2">

<input type="submit" value="search">

</form>

</td>

</tr>

</table>

 

<table border="0" width="400">

<tr>

<td width="200"><font color="#8B4513" face="verdana" size="1"><b>Food group search</b></font></td>

</tr>

<tr>

<form name="form3" method="post" action="index_search2.php" onsubmit="return validate(this);">

<td width="200" valign="center"><select name="product">

<option value="0">Please select food group</option>

<option value="agri">Agricultural Products</option>

<option value="alkohol">Alkoholic Beverages</option>

<option value="nonal">Non Alkoholic Beverages</option>

<option value="bakery">Bakery Products</option>

<option value="cannedfood">Canned Food</option>

<option value="cereals">Cereals, Grains, Flours</option>

<option value="candies">Candies, Snacks, Desserts</option>

<option value="sugar">Sugar, Honey, Sweeteners</option>

<option value="coffee">Coffee, Tea, Cacao</option>

<option value="condiments">Condiments, Spices, Herbs</option>

<option value="foodin">Food Ingredients</option>

<option value="fruits">Fruits and Vegetables</option>

<option value="dressings">Dressings and Seasonings</option>

<option value="meat">Meat, Meat Products</option>

<option value="milk">Milk, Cheese,Cream</option>

<option value="oil">Oil, Fats Products</option>

<option value="organic">Organic Products</option>

<option value="pasta">Pasta, Sauces, Soups</option>

<option value="ready">Ready and Convenience Food</option>

<option value="seafood">Seafood, Fish Products</option>

</select></td></tr>

 

<tr>

<td width="200"><select name="country">

                <option value="0">Please select country</option>

                <option value="Albania">Albania</option>\n

                <option value="Algeria">Algeria</option>\n

                <option value="Argentina">Argentina</option>\n

                <option value="Australia">Australia</option>\n

                <option value="Austria">Austria</option>\n

                <option value="Bahrain">Bahrain</option>\n

                <option value="Bangladesh">Bangladesh</option>\n

                <option value="Belarus">Belarus</option>\n

                <option value="Belgium">Belgium</option>\n

                <option value="Belize">Belize</option>\n

                <option value="Benin">Ben?n</option>\n

                <option value="Bolivia">Bolivia</option>\n

                <option value="Brazil">Brazil</option>\n

                <option value="Bulgaria">Bulgaria</option>\n

                <option value="Burkina Faso">Burkina Faso</option>\n

                <option value="Burundi">Burundi</option>\n

                <option value="Cameroon">Cameroon</option>\n

                <option value="Canada">Canada</option>\n

                <option value="Chile">Chile</option>\n

                <option value="China">China</option>\n

                <option value="Colombia">Colombia</option>\n

                <option value="Costa Rica">Costa Rica</option>\n

                <option value="Croatia">Croatia</option>\n

                <option value="Cyprus">Cyprus</option>\n

                <option value="Czech Republic">Czech Republic</option>\n

                <option value="Denmark">Denmark</option>\n

                <option value="Dominican Republic">Dominican Republic</option>\n

                <option value="Ecuador">Ecuador</option>\n

                <option value="Egypt">Egypt</option>\n

                <option value="Estonia">Estonia