I have never used phpgrid but the next step is to check the actual function which is taking your sql input provided by them using exit's and break's to output whats going on.
Its possible there is some checks to prevent sql injection etc and its automatically filtering your string.
Also what version of php are you running?
Ok - Firstly, thanks for you all your help people. I'll be hitting that 'Thank Post' button alot.
I got in contact with the developer, and got a response that if using $_POST I need to set a session variable and use that. It seems to work now.
Really like this phpgrid, so much so I brought a license for the school for what I'm doing as it just makes things so easy.
Have you got PHPmyAdmin running on your webserver? A handy little way to debug your query is to echo back your query and copy and paste it into SQL tab of the database table (supportstaff_section1_b) in question. I've solved half a dozen issues like that. I'd also be tempted to echo something from your phpConnection.php page just to make sure that connection is working. Quince
Hi not sure if you got this sorted already but hopefully this code will help
$date = new datetime( $_POST['dbDate'] );
$selecteddate = $date->format( 'Y-m-d' );
Also with your query you could write the follow as the variable will work in the double quotations.
$date = date_create( $_POST['dbDate'] );
$selecteddate = date_format( $date, 'Y-m-d' );
$query = "SELECT * FROM tbldetentions WHERE DateSetFor = '$selecteddate'";