[SOLVED] Mysql

[sstangle73]

$query="SELECT * FROM users where id = 0-20
$query="SELECT * FROM users where id = 21-40

 

i want it to do that but im not sure of the correct code can someone tell me please

[phpQuestioner]

maybe something like this:

 

<?php

if ($id <= 20) {
$id="something";
}
else {
$id="something2";
}

$query="SELECT * FROM users where id='$id'"

?>

[keeB]

<?php
$query="SELECT * FROM users where id >= 0 and id <= 20"
$q2 = "$query="SELECT * FROM users where id >= 21 and <= 40"
?>

[Barand]

or

 

$query="SELECT * FROM users where id BETWEEN 21 AND 40

[beboo002]

select * from abhi

where name =>5 and name <=10 ;

use this code insted of

$query="SELECT * FROM users where id = 0-20

 

[keeB]

or

 

$query="SELECT * FROM users where id BETWEEN 21 AND 40

 

Learn something new every day, didn't know about the BETWEEN keyword.

 

Thanks B!

[sstangle73]

yeah thats a nice feature to know thanks b thats the one i tried and it worked