Know i have adapted the code to convert but that does not seem to work...Disallowed implicit conversion from data type varchar to data type money, table 'PBSalesRes.dbo.Flights', column 'AdultCost'. Use the CONVERT function to run this query.
I did have a problem similiar to this with the date, i resolved it using this bit of code:
Code: Select all
$csds = str_replace("/","-",$canceldate);
$newcancel = date ("d M Y", strtotime ($csds));