Syntaxis question

[plasmahba]

How is the correct syntaxis for this expression

SELECT * FROM mydb WHERE number >= '$val1'

AND number <= '$val2 '

I have problems with the >=<

Thanx in advanced

[TheDefender]

Do a search in the MySQL manual for the expression BETWEEN. That's what you are looking for...

Something like:

SELECT * FROM mydb WHERE number BETWEEN '$val1' AND '$val2 ';

ref: MySQL Manual

[plasmahba]

Thanx it worked perfectly.

Also I´m checking the mysqlmanual. It was a good hint, thanks

[TheDefender]

Do yourself a favor and download the MySQL manual at mysql.com and the CHM version of the PHP manual from php.net. They come in very handy all of the time....