PHP MySQL Sorting Problem

[Nematoth]

I have a problem with MySQL in that when I perform the following:

$sqlquery3 = "select sub_no,sub_name from proj_sub where project_number='$project_number' ORDER BY sub_no;";

$result3 = mysql_query($sqlquery3);

while($row3 = mysql_fetch_array($result3))
{

$sqlquery4 = "INSERT INTO sub_image_issue
VALUES(
'',
'$issue',
'$row3[sub_no]',
'$project_number',
''
);";

$results4 = mysql_query($sqlquery4);
}

The second query 'sqlquery4' inputs data into the table 'sub_image_issue' in a bizarre order and not in the order specified in the query '$sqlquery3'

Any ideas why this might be happening?
Thomas Shearer
Multimedia Developer

http://www.pixelimage.co.uk

 

[KempCGDR]

If sub_no is a string field of any type, then they will be ordered character by character, ie:

1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20 etc etc

 

[KempCGDR]

By string, I obviously Varchar/Text/whatever