Home > front end >  Questions about ASP query classification
Questions about ASP query classification

Time:03-31

Two table, a table FXK is post content, there is every field, another table is fxk_class classification table, inside have id number (classification), the classname (classification), topid (parent class number) three fields, the relationship between the two tables is every corresponding id
In FXK ASP form page, there are three cells need to query fxk_class according to every field under different parent class number in the table id=every classname, and respectively according to

For example, the following code can query and display the parent class in a number 3 ID=every classname:
The set rsRepeat=conn. Execute (" select ID, the ClassName, TopID from fxk_Class where ID="& amp; Rs (" every ") & amp;" And Topid=3 ")
If not (eof) rsRepeat. Bof and rsRepeat. Then
The classname=rsRepeat (" classname ")
End the if

ASP form as shown in figure:


The second column for the above code is shown in [], the content of the column and column 10 8 [] should be how to display? Code should be how to write?

Online etc.! Come on come on!

CodePudding user response:

Didn't see you those agghh ah and aaa is which table which field, what is behind the two [],
  •  Tags:  
  • ASP
  • Related