Page Help

[Craigr]

I am trying to add custom php block to a created page.

My page URL is:
cmps_index.php?pageid=codetalkers

Is there any way i can then use this pageid in mysql query? This way i can have different results depending upon the category name.

I want to do:

  $randamazon = $db->query("
  SELECT amazon_id, amazon_productname, amazon_author, amazon_asin, amazon_rohcat, LEFT(amazon_description,200) AS amazon_description, amazon_filename, amazon_clicks
  FROM " . TABLE_PREFIX . "bb1_amazon
  WHERE amazon_rohcat = codetalkers
  ORDER BY amazon_productname");

Thanks.