ASP drop down menu to connect to the database

If it's multiple months, just modify the link.

Then submit the database query:

The yuefen field here is the month field when you record the data.

The easiest way to pop up is to use session or cookiesif session("adminame")="" thenend if

However, this is not safe, it is better to check the data with the database.

I think of a lot of ways to do this. Here I will teach you a simple way.

Do not use it for processing. Directly write the months connection as months.

Then display it on the database processing page, and add an id=request("id"And that's it.

Change your date selection to:

fori=1to

ifshowmonth=i

selected"%>>=i%> month.

next%>

Regarding the input of SQL statements, I have already told you in QQ.

Workaround for login timeout:

When your page needs to receive a parameter such as vhuk, this parameter means that when the value of the next menu changes to the province, refresh the address of the current page, and turn the selected province to remember to add points &

It's a query.

When you select it, an event is triggered, and this event is written to query the database.

Change your date selection to:

for i=1 to 12%>

if showmonth=i then "selected"%>>=i%> month.

next%>

Regarding the input of SQL statements, I have already told you in QQ.

Workaround for login timeout:

When your page needs to receive a parameter such as vhuk, this parameter means that when the value of the next menu changes to the province, refresh the address of the current page, and turn the selected province to remember to add points &

You don't need a table for each place name, right? Put it in a table and you can put it in a table <%if and then

Please add the city first. "else

%trim(rs("province"))end if

Origin. %while not output the place name loop %>

There's a drop-down menu for JS multi-level linkage.

The position and style can be customized to be more practical.

There are tutorials and source code inside.

The effect you want is not something like this.

In fact, the principle is also very simple, see the ** of the sid and id web page to get it like this.

Database statements.

Among them, the sid is a large column, and the id is a drop-down column.

I think you know how to do that next step by asking.

For example, there is a drop-down menu in it, from January to December, how to achieve the selection of that month, the link will change your date selection ** to:

do while not and notstrlist = strlist & rs(svalue) &'You can modify this sentence and modify it as follows:

strlist = the default value of strlist & (i.e. the value in the database you said" then strlist = strlist & selected >"else strlist = strlist & year, add a selected to the beam, indicating that the line is selected.

There is another sentence below, something like that. Sun Zha's eyes have a problem, you can hi me.

It's basically a matter of database table design.

You can set the value of the drop-down menu to the name of the table you want to query data from. If the questions are all in a table, then you can design a field in the table (what category the questions belong to). The answer is just a train of thought.

You add me hi and I will teach you how to do it

If both tables are numbered, this item can basically be achieved with the vlookup formula, and it is best to take a screenshot of table 1 and paste it.

1. The production method of the drop-down menu in Table 2:

1. Press CTRL+F3 to define the name: number, and the reference location: = Table 1!$a:$a 2、Select column A in Table 1 and set the data validity Series:=indirect(number)2、Formulas for other cells:

if(a1="","", vlookup ($a 1, Table 2!$a:$g,column(a1),0))

Probably so.