mysql question

Hey, is there anyway to make this

[code=php]
$query0 = ‘SELECT `id`, `cp` FROM cp WHERE `cp` = ‘.$usercp.’ ORDER BY `cp` ASC LIMIT 0,1′;
$resid = mysql_query($query0, $link) or die(mysql_error());
$curr = mysql_fetch_assoc($resid);
$max = $curr[‘id’] + 10;
$min = $curr[‘id’] – 10;
$query = ‘SELECT * FROM cp WHERE `id` BETWEEN ‘.$min.’ AND ‘.$max.’ ORDER BY `id` ASC’;
[/code]

in just one query???

Also in #PHP _↴