Little help with php string please

Why this code

$sql = 'SELECT pagerank FROM {website_pr} WHERE url=%s AND timestamp < %d';

PHP:

when I debug always shown the value :

SELECT pagerank FROM {website_pr} WHERE url=%s AND timestamp <

PHP:

and throwing away the %d ?!? Is there something I missed?

 

Try this

$sql = "SELECT pagerank FROM {website_pr} WHERE url='%s' AND timestamp < '%d'"

 

Oopps .. i wrote the wrong code ... it should be :

$sql = "SELECT pagerank FROM {website_pr} WHERE url='%s' AND timestamp<%d"

PHP:

 

Try:

$sql = "SELECT pagerank FROM {website_pr} WHERE url='%s' AND timestamp < '%d'";

PHP:

 

You need the timestamp variable to be in single quotes '%d'

 

Thanks for the replies, turns out that it's only the debugger that shows the incorrect value. So everything is all good now.

 

which debugger you are using????

 

zend debugger (eclipse)