Date: 05/23/06 (MySQL Communtiy)    Keywords: php

Hi all.

I created a Job Bulletin for my company, and although it's working just fine, I have been unable to get the table to sort by state automatically.

Right now, I have this script in my php file:

$query_JobForms = "SELECT * FROM job_list ORDER BY job_list.job_state ASC LIMIT 0, 30";

However, every time a new job gets added, it just goes to the top and doesn't order by state. What am I doing wrong?

Source: http://community.livejournal.com/mysql/95945.html