A query using BETWEEN
$sql = "SELECT
tblvendors.VendorID,
tblvendors.`Last Name`,
tblstalls.`Map#`
FROM tblvendors
INNER JOIN tblstalls ON tblvendors.VendorID = tblstalls.VendorID
WHERE tblstalls.`Map#`
BETWEEN $val1 AND $val2
ORDER BY tblstalls.`Map#` ASC
";
But the ORDER By doesn't seem to work. It still comes back as DESC - beginning with the value of $val2.
Doesn't ORDER BY work when you use BETWEEN?
