Problem with a query? or Syntax?

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello... Im having a problem with a php code that was running (and is running smoothly until today i guess). The code that's giving me the error is this: $sql = "select * from archivo where fecha between $fechaprima and $fechasegu"; $r = mysql_query ($sql); $num_de_rows = mysql_num_rows ($r); this line <- if ( $num_de_rows > 0 ) { (i create some html tables here) } The site is (www.passive-aggressive.org/pic_archive.php). The problem only happens when i select 08 as the month (i have a dropdown in which u can select which month u want and then i create the $fechaprima and $fechasegu from that date. Anyway... with all the other months im not getting any errors at all. However, I've done the query by hand at the mysql prompt and it is bringing me one row (the only one that exists for 08 month), so im guessing its invalid syntax, which is weird cause all the other months are running this "script" ok. The error im getting is: Warning: Supplied argument is not a valid MySQL result resource in /home/passive-/public_html/pic_archive.php on line 172 (line 172 is the one that i showed before) Any ideas? - -- Saludos, Romina N. Tulisi romina@spcom.com.ar Desarrollos Soluciones Punto Com http://www.spcom.com.ar -----BEGIN PGP SIGNATURE----- Version: PGP 6.0.2i iQA/AwUBO3wgu9gEND22jsQ3EQKSsgCfb18sc+b/hAI6WuZOjmKD6wUDy7YAn3GM 3Usgy3KSM1w/D2Q2G67oZCst =JAs/ -----END PGP SIGNATURE-----