This is entirely an SQL question. Please post in the appropriate forum.
Moving thread.
As for your question - I'm really not sure. I've used BETWEEN...AND syntax before, but in all cases, I've supplied the range, rather than making the range defined by column values.
Last edited by pickle on Fri Mar 02, 2007 10:34 am, edited 1 time in total.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post us what it says. But before you do, open up whatever it is you use to access mysql (mysql query browser, console, or whatever), and put the same query in straight to mysql. mysql's error control will give you more insight as to what is going on with it. Post the error that mysql gives you, not php.
or, you could just put "or die(mysql_error())" at the end of your statement.