[SOLVED] How to add a variable inside a Select query?

[CodeToad]

Here is what I'm trying to do:

 

$temp = 5;

 

$sql = 'SELECT * FROM database WHERE numid = "$temp"';

 

It doesn't work since I'm trying to assign a variable inside a variable, does anyone have any suggestions?

[redarrow]

$temp = 5;

$sql = "SELECT * FROM database WHERE numid = '$temp' ";

[Lumio]

You can use one of them:

$sql = 'SELECT * FROM database WHERE numid = "'.$temp.'"';

$sql = "SELECT * FROM database WHERE numid = '$temp'";

$sql = "SELECT * FROM database WHERE numid = '".$temp."'";

[CodeToad]

Thanks for the quick responses guys!  I had been google searching for a while with no luck.  I figured it was just syntax issues, but I'm new to this and didn't know any better.

 

You saved me a bunch of time, thanks again!