[SOLVED] using variable as limit

[severndigital]

can this be done? if so, i can't seem to figure it out.

 

using this query mysql doesn't like it.

 

$limvar = 3;

$sql = "SELECT * FROM table WHERE used='0' ORDER BY RAND() LIMIT '$limvar'";
   $pull = mysql_query($sql)or die(mysql_error());

 

when i run this query i get an error saying my syntax is wrong near "3" on line 1

 

if i run the exact same query but replace '$limvar' with the number 3 .. everything works perfect.

 

any ideas??

 

Thanks,

C

[br0ken]

$limvar = 3;

$sql = "SELECT * FROM table WHERE used='0' ORDER BY RAND() LIMIT $limvar";
   $pull = mysql_query($sql)or die(mysql_error());

 

I would try $limvar with out the speech marks around it as it's an integer and doesn't need these.

[severndigital]

That worked perfectly .. thanks.