Jump to content


N00B-Why won't my records sort?

  • Please log in to reply
1 reply to this topic

#1 reazik

  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 12 April 2006 - 04:53 PM


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:

mysql_select_db($database_JobForms, $JobForms);
$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?


#2 moberemk

  • Members
  • PipPipPip
  • Advanced Member
  • 695 posts

Posted 12 April 2006 - 09:53 PM

If this is a script that you're modifying, should this be in the Third-Party Scripts forum?
Disclaimer: No matter how harsh I may be, I'm always IMO only.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users