Wil — Wed, 16 Jan 2002 11:05:48 +0000

OK. Now, using the information I provided in the above post you can modify this query to be sorted by a paticular field.

Pass the order you want the results to the script. If no order is passed, I'll assume that you want them sorted by "uname".

$sort = $query->param('sort') || "uname";

$sql = "select date, uname, exsal from biopersonal where publish='y' 
and (job='database' or job1='database' or job2='database') <strong>ORDER BY $sort</strong>";

$result = mysql_query($sql);

[ untested code ]

joyce — Wed, 16 Jan 2002 09:58:10 +0000

this is the $query i used to select out the records..

<?php
$sql = \"select date, uname, exsal from biopersonal where publish='y' and (job='database' or job1='database' or job2='database')\";
    $result=mysql_query($sql);
?>

Wil — Wed, 16 Jan 2002 09:51:37 +0000

By using ORDER BY and passing the field you want ordered by to the script. Your script will then query the database using the ORDER BY field passed to it.

To get the correct up/down images, you will need to establish what value the sort order is, and then do a conditional statement to work out what image to display.

Have you done any coding yet? If so, could you post the relevant bits? As in, how are you retrieving the records from the database?

joyce — Wed, 16 Jan 2002 09:43:52 +0000

i have this three field:

<?php
print \"<tr><td width=30% bgcolor=#9999ff align=center><font face=verdana color=#ffffff size=1>Date</font></td>\n\";
    print \"<td width=40% bgcolor=#9999ff align=center><font face=verdana color=#ffffff size=1>Name</font></td>\n\";
    print \"<td width=30% bgcolor=#9999ff align=center><font face=verdana color=#ffffff size=1>Expected Salary</font></td></tr>\n\";
?>

they are actually titles, below them will have a list of records. how am i going to do it in such a way that when i clicked the title 'name, all the records i have below will sort by acsending and an arrow pointing up and when i clicked one more time, they will sort by descending order and an arrow pointing down.

Wil — Wed, 16 Jan 2002 09:37:21 +0000

You're using a SELECT statment on a SQL database, right? It's quite hard to help you without more information, but usually you just need to tell your SQL server in what order you want the results returned.

You need something like this:

SELECT field FROM database ORDER BY field