Need help with getting the information to display in Alphabetical order

[craigbruiners]

This is the query:

 

$tech = "  select d.doc_id, d.doctype_id, d.doc_summary, d.doc_title, p.dpdf_name,

              doc.doctype_title, doc.doctype_img, doc.doctype_img_alt, d.doc_textversion

              from doctype doc,document d left join pdf p on d.dpdf_id = p.dpdf_id

              where d.doc_id='".base64_decode($_GET['id'])."' and

              d.doctype_id=doc.doctype_id order by d.doc_title asc";

 

Because at the moment it displays the results in any order.

 

Thanks in advance.

[Yesideez]

If you post this in the correct section you may get help quicker.

 

http://www.phpfreaks.com/forums/index.php/board,3.0.html