attempt at sorting query results

[Enlightened]

Hello,

Im trying to sort results according to dates posted but a user.

I think parts of the mysql syntax i might have made up (oddly as it sounds)

On submit, It shows blank, (this usually happens when the query is funky),

Ive tried google and reading some post, Just havent found what ive been looking for

error_reporting is E_ALL, If anyone could direct me i'd appreciate it 🙂

<?php
error_reporting(E_ALL);
if(isset($_POST['date1']) && (isset($_POST['date2'])))

{	

require('../db/db_inc.php');

$date1 = $_POST['date1'];

$date2 = $_POST['date2'];


	$query2 = "SELECT CONCAT_WS(' ', first_name, last_name) as name, user_id as pay_id, accnt as accnt, pay_type as pay_type, amount as amount,

	AES_DECRYPT(d_ssn, @salt) as ssn, creditor as creditor, address as adress, city as city, state as state, zip as zip, phone as phone, 

	pay_date as date FROM contact WHERE date IS =>" . $date1 . " AND <= " . $date2 . " ORDER BY date ASC";								


	$result2 = mysql_query($query2);

[Azala]

There is no point in having "as" between two fields when you use the same name.

E.g: creditor as creditor

This serves no purpose, delete " as creditor" and do the same in all the other places this occurs.

Remove the IS in WHERE date IS =>.

What's with the excessive use of AS anyway?

[Enlightened]

Heres my latest attempt with your suggestion, Yielding the same results,

Does everything appear correct?

	require('../db/db_inc.php');

$datea = $_POST['date1'];

$date1 = date("m/d/y", $datea);

$dateb = $_POST['date2'];

$date2 = date("m/d/y", $dateb);


	$query = "SELECT CONCAT_WS(' ', first_name, last_name) as name, user_id as pay_id, accnt, pay_type, amount,
	pay_date as date FROM contact WHERE date => " . $date1 . " AND <= " . $date2 . "  ORDER BY date ASC";								

[kakki]

what about :
...
WHERE date => " . $date1 . " AND date <= " . $date2 . "

instead of
...
WHERE date => " . $date1 . " AND <= " . $date2 . "