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 ...


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]

Reply via email to