Simple query mySQL to sort but error, please help

[vboard22]

Hi guys

I happen to have to debug this page, and it has a querry out of database like this

   $selectSQL="SELECT * FROM recentipo_item_master WHERE insertdate<= ".$fromdate." AND insertdate>=".$todate ;

I want to sort the result by a collumn in the database named Issue, so my code is

  $selectSQL="SELECT * FROM recentipo_item_master WHERE insertdate<= ".$fromdate." AND insertdate>=".$todate ORDER BY issue ASC ; 

But i got error back, Can anyone please help me?

[vboard22]

nvm i figure it out, thanks anyway

[coopster]

I'm guessing you discovered that you forgot to concatenate the last part as a text string ;)

Glad you got it sorted and welcome to WebmasterWorld vboard22.

[vboard22]

Sorry I didnt come back a while, thanks for the welcome. :)