I'm trying very hard to do something that is probably simple. I have a job bulletin that is updated on a daily basis. (note, this script was pre-existing, and I have been modifying it myself)
I would like table to sort the jobs by state by default whenever the page loads. At first, I wanted to be fancy and have clickable titles that automatically sort by that column, but have given up on that.
I used the Recordset command to sort the table, which provides this code:
$query_JobForms = "SELECT * FROM job_list ORDER BY job_list.job_state";
$JobForms = mysql_query($query_JobForms, $JobForms) or die(mysql_error());
$row_JobForms = mysql_fetch_assoc($JobForms);
$totalRows_JobForms = mysql_num_rows($JobForms);
But when I load the page, it still doesn't order correctly. What am I doing wrong?
[a href=\"http://psninc.net/jobsort.txt\" target=\"_blank\"]Here is the entire code.[/a]
Can anyone help?
N00B-Why won't my records sort?
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users