Jump to content


Photo

N00B-Why won't my records sort?


  • Please log in to reply
1 reply to this topic

#1 reazik

reazik
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 12 April 2006 - 04:53 PM

Hi.

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:

<?php
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?

Rachel

#2 moberemk

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