ODBC Like Error

[Coruba67]

Hi guys,

am having an issue with sending an SQL query to the PHP ODBC Link...
using the following code

$date = date("d/m/Y");

// query the users table for name and surname

$querystuff = "SELECT * FROM SERVCARD WHERE statuscode='ALLOCATED' AND player='$uname' AND date LIKE '%$date%'";

// perform the query
$resultjobs = odbc_exec($connect, $queryjobs);
It all works perfectly until I put the AND date LIKE '%date%' into it

I get this error

Function argument value, type, or count is invalid., SQL state 37000 in SQLExecDirect in X:\webs\getstuff.php on line 23

I can print that variable to the screen no worries.. I just can't use it in this Query... any idea's?

Thanks in advance!

[nemonoman]

Probably the value in the column 'date' is not in the form you think it is.

Also some databases, such as MySQL, allow a "LIKE" comparison to dates...but not all databases allow this comparison, as it requires the date column to be recast as text for comparison.