Re: [PHP] writing a query that returns similar numbers

[mike cullerton]

select rowid from numbers where number between mynumber-10 and mynumber+10;

on 7/4/79 10:48 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:

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


 -- mike cullerton



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