Webmaster Forum / PHP / Database Access / August 2008

I'd like to store the information to generate a combobox (drop down
menu) in the MySQL database. What is a good way to do this. Store the
name, value pairs in a separate table apart from the combobox-question
table or store it in a VARCHAR field as a JSON value?

I'd like to store the information to generate a combobox (drop down
menu) in the MySQL database. What is a good way to do this. Store the
name, value pairs in a separate table apart from the combobox-question
table or store it in a VARCHAR field as a JSON value?

My 'mysqlconnect.php' simple connection test script returns a browser
message
   "PHP Fatal Error: Class 'Mysqli_connect" not found in c:\\program
files\apache group\ .....\mysqlconnect.php"

I've a table in with I've a field called "year".
Now this is not what we want anymore but instead we want a value defining
the "period":
table period