Data sorting

agmorgan

Hi, I have written a little section that extracts data, however I would like to sort it, However my referance books don't seem to help...

I added a rsort after the extract row line

$query = "SELECT * FROM allocated WHERE EmpRef = $Review ";

$result = mysql_query($query) or die ("Couldn't execute query.");

while ($row = mysql_fetch_array($result))
{

extract($row);
rsort($row);

$query1 = "SELECT * FROM Assignment WHERE AssCode = $AssRef ";

$result1 = mysql_query($query1) or die ("Couldn't execute query1.");

$row1 = mysql_fetch_array($result1);

extract($row1);

echo "<table width = '700'>";
echo "<tr><td width ='150'>$AssRef </td>
<td width = '150'> $AssJT </td>
<td width ='150'> $AssCo </td>
<td width ='150'> Date $AssStart</td></tr> \n ";
}

Roger_Ramjet

First problem is that using rsort on the $row is going to just rearrange the fields in 1 record according to their values. I'm sure that is not what you mean or want. If you want the records sorted in a specific order then do it in the query. You don't actually indicate what column you want to sort on, although rsort means in reverse ,or descending order.

So I'm just going to give a generic example

$query = "SELECT * FROM allocated WHERE EmpRef = $Review ORDER BY col DESC ";

As to the query itself, you are making the usual mistake of running multiple queries in a loop. There times when that is neccessary, I mean when nothing else will work, are so rare as to be non-existent. So any time you see, or find yourself using queries in a loop then you know you've got it wrong and it's time to start again.

To get related data from two or more tables you use a JOIN

$sql = "SELECT * FROM allocated x INNER JOIN assignment y ON(x.assref=y.asscode) WHERE EmpRef = $Review ORDER BY what_ever_column_you_need ";