can any one tell me how can i retrive value from Database in SELECT form
Code: Select all
<SELECT NAME="category">
WHAT WILL BE THE SQL STATEMENT AND HOW TO WRITE HERE TO GET CATEGORY FROM DATABASE
</SELECT>Database Tables Name and Field
pa_categories
category_id
category_name
pa_subcategory_category_map
subcategory_id(parent category)
category_id ( child category )
please tell me how can i get value in Select form from data base
thank you in advance
waiting for reply