Hello!
I have trouble whith MAX(). I want to select the highest number and use that number in my next query. I have tried to use this query: "SELECT * FROM table where nr ='(SELECT MAX(nr)FROM table)' but it dosen't work.
/Lotta
Assuming that you are stuck with Mysql.
if you wish to get all columns
select * from table order by id desc limit 1
or if you just need nr
select max(nr) as nr from table
Yes, because MySQL (as good as it is) <B>DOESN'T SUPPORT SUB-QUERIES</B> (and foreign keys, and transactions, etc...)
fLIPIS
