Skip to content
This repository has been archived by the owner on Mar 28, 2020. It is now read-only.

Where between is not working #13

Closed
matthieugluszkowski opened this issue Nov 29, 2018 · 1 comment
Closed

Where between is not working #13

matthieugluszkowski opened this issue Nov 29, 2018 · 1 comment

Comments

@matthieugluszkowski
Copy link

Hello,
I would like to do this request, but it's not working, could you help me?

$db->select($table, [
'latitude' => 'Between "48.864690367882"',
'latitude' => '"48.900663232118"'
], false, false)->result();

The request SQL is : SELECT * FROM table WHERE latitude Between "48.864690367882" And "48.900663232118" And longitude Between "2.2993563961954" And "2.3540594038046"

Thank you in advance

@tschoffelen
Copy link
Owner

tschoffelen commented Nov 29, 2018

The only way to do that currently is the following:

$db->select($table, [
'latitude BETWEEN "48.864690367882" AND "48.900663232118"'
])->result();

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants