[PHP] writing a query that returns similar numbers

[[EMAIL PROTECTED]]

I have a database with numbers in one of the tables I'd like to ask mysql to
renturn all numbers with say 10 of mynumber

Sort of like this:

$sql = "SELECT rowid FROM numbers WHERE (mynumer is within 10 of number)";


but I've gotten stuck do I have to do this:


$sql = "SELECT rowid FROM numbers WHERE (((mynumer+10) < number) AND
(mynumer-10) > number) )";

it seems kinda wordy ...

Susan


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]