Where to insert the 'Order By' clause in this query

Hi,

Got the following statement but I need to order results by the 'Title'
column.
How to do that within the current fragment?

<?
$pos=0;
while($rec=mysql_fetch_assoc($result))
{
$r=mysql_query("SELECT * FROM `$tbl_prs` WHERE `ID`='".$rec['PRID']."'");
$record=mysql_fetch_assoc($r);
?>

Regards,
Daniel

Daniel Hesselink wrote:
> Hi,
>
> Got the following statement but I need to order results by the 'Title'
> column.
> How to do that within the current fragment?
>
> <?
> $pos=0;
> while($rec=mysql_fetch_assoc($result))
> {
> $r=mysql_query("SELECT * FROM `$tbl_prs` WHERE `ID`='".$rec['PRID']."'");
> $record=mysql_fetch_assoc($r);
> ?>
>
> Regards,
> Daniel
>
>

Set it last in your querry.