Passing variable to SQL query

[newbiePHP]

hey guys,

 

I am trying to sort out an SQL statement.

 

The below statement will return nothing when it's executed.

 

$date="2007-08-28 15:24:44";
$sql = 'select * from example order by abs( unix_timestamp(`$date`)- unix_timestamp(datetime) ) limit 1'; 

 

The problem is when I hardcode in vehicledate,(see below) it works just fine.

 

$sql = 'select * from example order by abs( unix_timestamp("2007-08-28 15:24:44")- unix_timestamp(datetime) ) limit 1'; 

 

I assume there is some problem passing variables into SQl statements.

 

Does anyone know how to get this to work. In my PHP script I will be taking in the date from a website so hardcoding it in is not an option.

 

Any help would be appreciated.

 

Thanks

[enoyhs]

It is because variables won't work in single quotes.

$sql = 'select * from example order by ' . abs( unix_timestamp('$date')- unix_timestamp(datetime) ) . ' limit 1';

[newbiePHP]

I tried that but it gave me this error

 

Fatal error: Call to undefined function unix_timestamp() in C:\wamp\www\test1.php

 

[enoyhs]

That must be because unix_timestamp() is SQL function...

Try this:

$sql = "select * from example order by abs( unix_timestamp('$date')- unix_timestamp(datetime) ) limit 1";

[newbiePHP]

That worked beautifully. great job

 

Thanks a lot