I have a table with 2 columns I need to sort. The first column is "id" and the second is "job". As jobs are entered into the database they are giving an "id" but if 2 people are working on the same job then the "job" field is given the same number as the "id" field. For example:

id job
1
2
3
4 2
5

So I would like the order to show up as rows with the following id: 1, 2, 4, 3, 5
so that the job show as such: 1, 2, 2, 4, 5

The ordering does not come out correct. Here is the php

PHP Code:

<?php
//create order by
$query="SELECT * FROM lss WHERE month=$month AND day=$day";
$result = mysql_query($query) or die("Couldn't execute query: ".mysql_error());
while ($rows=mysql_fetch_array($result)) {
$id=$rows['id'];
$jobdb=$rows['job'];
if ($jobdb=="") {
$job="id";
} else {
$job="job";
}
}
//list
$query="SELECT * FROM lss WHERE month=$month AND day=$day ORDER BY $job";
$result = mysql_query($query) or die("Couldn't execute query: ".mysql_error());
?>

i have found my error

I need to wrap the while {} around both queries

For future reference, ORDER BY clause, eg

select id, job-id from my-table order by id, job-id

Originally Posted by PaulW

For future reference, ORDER BY clause, eg

select id, job-id from my-table order by id, job-id

Keep in mind from Paul's comment that the ORDER BY goes in order of columns listed from left to right. So the two examples below would result in two different results.

ORDER BY id, type

ORDER BY type, id