select where id is between 2 numbers

[flemingmike]

is this a proper way of entering this?

 

$result = mysql_query("SELECT * FROM jobs WHERE id2 >= '$startdate' AND id2 < '$enddate' ORDER BY id");

[Pikachu2000]

BETWEEN . . . AND . . .

[chintansshah]

use belwo query

 

$result = mysql_query("SELECT * FROM jobs WHERE id2 BETWEEN '".$startdate."' AND '".$enddate,"' ORDER BY id");

[flemingmike]

is it possible to also add in

 

WHERE status = '$status'

 

so something like

 

$result = mysql_query("SELECT * FROM jobs WHERE status = '$status' WHERE id2 BETWEEN '".$startdate."' AND '".$enddate,"' ORDER BY id");

[flemingmike]

i currently have this, but no results show

 

$result = mysql_query("SELECT * FROM jobs WHERE (id2 BETWEEN '$startdate' AND '$enddate') AND (status = '*') ORDER BY id");

[flemingmike]

my status='*'  is actually status='$poststatus'

 

i have it working, i just dont know how to show all statuses.  i tried *, but no luck

[litebearer]

if you do NOT use the AND "status = " it will show all. use the "status = " to limit the status to cetain ones

[flemingmike]

what can i put to show everything though?

 

i have different links that will set $poststatus

 

one of the links is display all.  so what can i put in the status=' '  to make it show all statuses?