Brian@nif2
02-14-2006, 05:04 PM
Hi guys
I'm only starting to cut my teeth in dreamweaver, and using it as the basis to try and pick up php and mysql.
I'm trying to do something which I think should be fairly straightforward, but I don't know the correct command to make it work.
In Dreamweaver, I'm trying to tell the query to Filter the record by 2 feilds, I can get it to sort the first field, but when I try and add a second field to sort it won't work, probably becuase I'm not telling it the right command, or writing it wrong
Here is the codeing that works, from the advanced recordset in Dreamwaver
SELECT *
FROM nif2_dprofiles
WHERE Formula = ''F2''
ORDER BY Number ASC
From that I want to add a second filter eg WHERE Rowb = "X"
the second thing I want to do is add a second Sort on it, so that it sorts first by Number, then by a second field, "Number2", again, how do I add this second field into my coding?
All help is greatly appreciatted.
I'm only starting to cut my teeth in dreamweaver, and using it as the basis to try and pick up php and mysql.
I'm trying to do something which I think should be fairly straightforward, but I don't know the correct command to make it work.
In Dreamweaver, I'm trying to tell the query to Filter the record by 2 feilds, I can get it to sort the first field, but when I try and add a second field to sort it won't work, probably becuase I'm not telling it the right command, or writing it wrong
Here is the codeing that works, from the advanced recordset in Dreamwaver
SELECT *
FROM nif2_dprofiles
WHERE Formula = ''F2''
ORDER BY Number ASC
From that I want to add a second filter eg WHERE Rowb = "X"
the second thing I want to do is add a second Sort on it, so that it sorts first by Number, then by a second field, "Number2", again, how do I add this second field into my coding?
All help is greatly appreciatted.