Select * from x+1

no!

but you can
SELECT * FROM MENUCAT
UNION
SELECT * FROM MENUCAT1
UNION
SELECT * FROM MENUCAT2
.
.
.

and IF your table name is

MENUCAT+1

then try

[MENUCAT+1]

Hvordan fungerer det? UNION?

Table name is MENUCAT and i need to get the first 4 things from the database, but using top 4 is out of the question...

OK so you only have ONE table!
Why cant you use TOP 4?

can you explain what it is you are trying to do so we can make some suggestions

a UNION "unites" the result of two or more SQL SELECTS. The field types need to be the same for each table, but if they are from the same table then that should be no problem!

I wanna make a menu where it selects 4 sub catagories, and then posts the links linkd to that catagory underneath it.

So first i take all from the table ie Community where there are the links: forum, members ect

Then i wanna go further down and select the next in the database, and write out the links under that catagory... all in all i want 4 catagories, were links with the catagory is posted in...

still not sure what you mean! can you decribe the table layout?

http://80.199.147.15/layout/

Thats what i wanna do... based on 2 tabels in my database. The database called MENUCAT and a database called SUBSITES

can you send me your dB (zipped) so that I can see the tables and fields?

I can more than likley give you an SQL which will give the data you want but I think it will still require you to program in ASP to display the data.

NOSPAMeksperten@santhell.dkNOSPAM

you need to remove NOSPAM

The result I think I can give you will be like this

Catagory 1 Link 1
Catagory 1 Link 1
Catagory 1 Link 1
Catagory 1 Link 1
Catagory 2 Link 2
Catagory 2 Link 2
Catagory 3 Link 3
Catagory 4 Link 4
Catagory 4 Link 4
Catagory 4 Link 4
.
.

so in your ASP code you loop through the recordset until Category changes

Sending DB now.

Thx :D

*Increasing points*

SELECT MENUCAT.MENUCAT, SUBSITES.HEADLINE, SUBSITES.TEXT, SUBSITES.LINKNAME, SUBSITES.PICTURE
FROM MENUCAT LEFT JOIN SUBSITES ON MENUCAT.ID = SUBSITES.MENUCAT
ORDER BY MENUCAT.ORDER;

Looked at this, and i get no errors when i run the script through conn.execute.

But how can i slipt this up so it will look like the site i showed you?

split*

Bruger følgende kode:

    <%
        strSQL = "SELECT * FROM MENUCAT"
        Set rs = conn.execute(strSQL)
       
        Do
       
        strMENUCAT = rs("MENUCAT")
        strMENUCATID = rs("ID")
       
        Response.Write("<br>")
        Response.Write(strMENUCAT)
        Response.Write("<br>")
       
        strSQL2 = "SELECT * FROM SUBSITES WHERE MENUCAT ="&strMENUCATID
        Set rs2 = conn.execute(strSQL2)
       
        Do
       
        strLINKNAME = rs2("LINKNAME")
       
        Response.Write(strLINKNAME)
        Response.Write("<br>")
       
        rs2.movenext
        loop while not rs2.eof
        rs2.close
        set rs2 = nothing
       
        rs.movenext
        loop while not rs.eof
        rs.close
        set rs = nothing
    %>

tak :o)