PHP/Mysql query by SearchDate variable

I have a form that my customers use to check all the new items added by the DatePosted field of the database.

They select a PositionType from a dropdown menu and enter a begin date as in 20121001 and the result would be a list of all the positions that were added from their searchdate (20121001 to today.

Here is the last one that worked before the server was upgrade to the new versions of php and mysql and would list the today of positions between the SearchDate and Today

$result = mysql_query("SELECT Count(*) AS total FROM jobs WHERE PositionType = '$PositionType' AND '$SearchDate' <= DatePosted ORDER by JobState");

$job_count = mysql_result($result, 0, 'total');

and the last code to work that listed the positions was:

$sql = "SELECT DATE_FORMAT(DatePosted,'%m/%d/%y') AS Date1, DATE_FORMAT(ClosingDate,'%m/%d/%y') AS Date2, JobID, DatePosted, PositionTitle, PositionType, JobCity, JobState, ClosingDate FROM jobs WHERE PositionType = '$PositionType' AND DatePosted >= $date[now] AND '$SearchDate' ORDER by JobState";

$result = mysql_query($sql);

So for a small fee I wish to have someone look this over, give me the code to try and when it works I will pay you a small fee as this should be easy for someone that knows what there are doing... I thought I did but it is not working.

Skills: MySQL, PHP, Software Architecture

See more: searchdate php, searchdate, php and mysql jobs, n.y. jobs, n.y.c. jobs, database positions, jobs in architecture, software architecture php mysql, php software architecture mysql, mysql query, mysql dropdown, mysql and sql, php form dropdown list, server upgrade php, mysql date field, menu select php, sql select order, variable mysql, php mysql database query, mysql database query form

About the Employer:
( 43 reviews ) Port Charlotte, United States

Project ID: #2563360

Awarded to:


I have 5+ yrs of experience in PHP & MYSQL. I can finish your work ASAP.

$30 USD in 1 day
(3 Reviews)

9 freelancers are bidding on average $34 for this job


Greetings! Best of to assist you on your project. I offer you the highest level of skill. Please view PMB for our portfolio. Best regards, AHT SERVICE AND TECHNOLOGY DEVELOPMENT JSC

$50 USD in 1 day
(293 Reviews)

Please check private message .

$40 USD in 1 day
(99 Reviews)

Hi, let start right now

$30 USD in 1 day
(89 Reviews)

Ready for service sir, thanks.

$30 USD in 1 day
(75 Reviews)

I am ready

$30 USD in 0 days
(4 Reviews)

ill do that sir....acvcept me...thanks

$30 USD in 1 day
(0 Reviews)

Hello, I'm a french web developer who needs extra money for a personal project. I need more details on the problem. As far as I can see, your requests should not be the problem even in case of a server update. SQL More

$35 USD in 1 day
(0 Reviews)

Hi, I have good knowledge in PHP ,MySQL technologies. I am very much interested to do your task.

$30 USD in 1 day
(0 Reviews)