how to search sql with from and to

gilgalbiblewhee · #1 (**permalink**) 02-10-11, 16:05

Is there a proper syntax or method of doing the following?

Quote:

$query = "SELECT * FROM ".$dbTable7." WHERE [from] book = '" .$book. "' AND [from] chapter= '" . $chapter. "' [to] book = '" .$book. "' AND [to] chapter= '" . $chapter. "' ORDER BY id ASC";

r937 · #2 (**permalink**) 02-10-11, 16:22

Quote:

Originally Posted by gilgalbiblewhee

Is there a proper syntax or method of doing the following?

you forgot to mention what "doing the following" is supposed to accomplish

for starters, remove the [from] and [to] business

gilgalbiblewhee · #3 (**permalink**) 02-10-11, 16:57

Quote:

Originally Posted by r937

you forgot to mention what "doing the following" is supposed to accomplish

for starters, remove the [from] and [to] business

:)

Yes. I know it doesn't belong there. But what I want to know is how to select from a certain book and chapter to another book and chapter...whatever is in between.

r937 · #4 (**permalink**) 02-10-11, 17:34

Quote:

Originally Posted by gilgalbiblewhee

... how to select from a certain book and chapter to another book and chapter...whatever is in between.

Code:

WHERE ( book > $bookfrom
     OR book = $bookfrom
    AND chapter >= $chapterfrom )
  AND ( book < $bookto
     OR book = $bookto
    AND chapter <= $chapterto )

Internet Services

Web Development

Digital Marketing

Consumer Tech