Hi Jai,
Well this is the first time Ive ever been able to help anyone out, hope this works it did for me.
First in you cfg file add
$db_table_reqfield (call it whatever you want really)
Then in the the db.cgi copy and paste this sub
sub build_select_field_from_db
and rename it build_select_field_from_reqfield (or once again what ever you want to call it)
then in the new sub replace this line
SELECT DISTINCT $column FROM $db_table
with
SELECT DISTINCT $column FROM $db_table_reqfield (the same as you called it in the cfg file)
The last thing to do is add the info into the html file where you want to use it.
e.g
print &build_select_field_from_reqfield("reqfield",$rec{'reqfield'})
(call it the same as you did in the db.cgi file)
Hope that works for you.
Cheers
Zero73
Sydney, Australia
Well this is the first time Ive ever been able to help anyone out, hope this works it did for me.
First in you cfg file add
$db_table_reqfield (call it whatever you want really)
Then in the the db.cgi copy and paste this sub
sub build_select_field_from_db
and rename it build_select_field_from_reqfield (or once again what ever you want to call it)
then in the new sub replace this line
SELECT DISTINCT $column FROM $db_table
with
SELECT DISTINCT $column FROM $db_table_reqfield (the same as you called it in the cfg file)
The last thing to do is add the info into the html file where you want to use it.
e.g
print &build_select_field_from_reqfield("reqfield",$rec{'reqfield'})
(call it the same as you did in the db.cgi file)
Hope that works for you.
Cheers
Zero73
Sydney, Australia