<select name="post">
<option value="clerk">clerk</option>
<option value="manager">manager</option>
and next
Code: Select all
<select name="pro_type"><option >select one</option>
<?php
require_once ('../../dbconnect.php');
$query = "SELECT post_id,post_name from position";
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo "<option value=\"{$row['post_id']}\">{$row['post_name']}</option>\n";
}
?>
</select>if i do first one i see
it will take larger DB space as it is varchar
and may be comparision will be slower post like ...
and it will be static and i need to change in code to add post
but if i do second one
every time when i display total job profile
after doing
select * from jobs where job_id=$id;
i have to make query
pos_id=$row['post_id']};
select post_name from position where post_id=pos_id;
similary in single file i have many such field like country,experiecne,qualification...
that way i need some extra select for each such data
and i need table for each such field what to do