Help with variables

[thomasw_lrd]

I've got a select statement that looks like this in php.

$sql = "Select * from inventory where ".$fields."".$operator."".$criteria;

Everything posts correctly, everything is dereferenced correctly.    My only question is how do I get $criteria have single quotes around it?

 

So that when I actually run the query it says

 

select * from inventory where field = 'value';

 

 

I've tried

$sql = "Select * from inventory where ".$fields."".$operator.""'.$criteria';

$sql = "Select * from inventory where ".$fields."".$operator.""'$criteria';

and a bunch of variations like that. 

 

Thanks for you help.

 

 

[Maq]

Look up interpolation:

 

$sql = "Select * from inventory where $fields $operator '$criteria'";

[thomasw_lrd]

Thanks I knew it was a stupid error on my part.

 

I had actually tried

 

"select * from ". $fields $operator '$criteria';

 

But that didn't work, and I didn't think of trying any other variations of that. 

[Maq]

You can do it that way but you have to concatenate everything:

$sql = "select * from " . $fields . " " . $operator . " '" . $criteria . "'";