[SOLVED] Problem adding ORDER BY

[jtwoody]

Hope someone can help,

I have this line:

$sql="select  nBusId $ftchflds from iscriptseitbl_product where nUserId=".$_SESSION["guserid"];

which works (although the quote marks baffle me a bit)

I need to add

ORDER BY Business_Name

But no combination of quotes and brackets is working.

Cheers

[Symmetry]

try

 

$sql="select `nBusId` $ftchflds from `iscriptseitbl_product` where `nUserId`='{$_SESSION['guserid']}' ORDER BY `Business_Name`";

[jtwoody]

Will you marry me?

Awesome. Thanks Symmetry

[Symmetry]

Np! Those { } brackets are really convenient sometimes.