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
Try the LIKE wording in your statement. That should workI think
- Original Message -
From: [EMAIL PROTECTED]
To: PHP Mailingliste [EMAIL PROTECTED]
Sent: Wednesday, July 04, 1979 12:48 PM
Subject: [PHP] writing a query that returns similar numbers
I have a database with numbers
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
similar numbers
Try the LIKE wording in your statement. That should workI think
- Original Message -
From: [EMAIL PROTECTED]
To: PHP Mailingliste [EMAIL PROTECTED]
Sent: Wednesday, July 04, 1979 12:48 PM
Subject: [PHP] writing a query that returns similar numbers
I have a database
4 matches
Mail list logo