Jump to content

Passing variable to SQL query


newbiePHP

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/74434-passing-variable-to-sql-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.