SELECT by alpha

[Anon]

Hi,

Im trying to get a SELECT to return some values in alphabetical order.

My query looks like this

$str1="select TblCpMembers.MEmail,TblCpMembers.MTitle,TblCpMembers.MFname,TblCpMembers.MLname,TblCpMembers.MCPos from TblCpMembers where CpId=$row[0]";

The query works but not alphabetically

CpName being the value I want sorted alphabetically.

Thanks

Mark R

[kparker]

Just add "ORDER by CpName" to the end of your query string and you're done!

[Anon]

Thanks for your help

🙂

works great