Sorting

[intosite]

Hi there,

I've got a SQL table with 3 fields in it. 2 of which or INT and the other text.
How can i sort it by one of the fields (refNo) which is numeric?

This is the script i used to retrive the info

$sql="select * from series";
$query=@($sql,$connection);
$varis="";
print "&varSeries=";
while ($list = @mysql_fetch_array($query)) {
print $list['id']."^";
print $list['name']."^";
print $list['refNo']."|";
};
print "&eof1=ok&";
mysql_close($connection);

Cheers

Isaac

[cschotch]

Sort it when you do the select statement like this...

$sql="SELECT * FROM series ORDER BY refno";

try that

[intosite]

I've tried that. It works.

Thanks

Isaac