$conn=ifx_connect("tjcx@picckfk","jlcx","jlcx2000;
$query="select tjdate from f001 ";
$query.="group by tjdate order by tjdate";
$result=ifx_prepare($query,$conn);
ifx_do($result);
$row=ifx_fetch_row($result,"LAST");
for ($i=1;$i<=10;$i++)
{
$tjdate=$row[tjdate];

echo '$tjdate';
echo "<option value=\"",$tjdate,"\">";
echo $tjdate;
echo '</option>';
$row=ifx_fetch_row($result,"PREVIOUS");
echo ($row);
if ($row==FALSE)
{break;}
}
I get array is ascending,I changed {$row=ifx_fetch_row($result,"LAST");} to {$row=ifx_fetch_row($result,"FIRST");}
But I get same result.
Can you help me!!