Get names of cookies and run them against database

[sharapov]

I have set several cookies on the page. Now I need to get the name of each cookie I set, and run it against my database if the name from the cookie matches the "ID" in my database I want to display this record. Can anybody help?

I tried to do the following, but it doesn't work:

<?

if (isset ($_COOKIE)) {
    while (list ($cname, $cvalue) = each ($_COOKIE)) {

@ $db = mysql_pconnect("localhost", "my_login", "my_password");

if (!$db)
  {
     echo "Error: Could not connect to database.  Please try again later.";
     exit;
  }

mysql_select_db("catalog");

$query = "select * from pricelist where item_number = '$cname'";
$result = mysql_query($query);

$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)
  {
     	$row = mysql_fetch_array($result);


$item_number = stripslashes($row["item_number"]);
echo $item_number;

$description = stripslashes($row["description"]);
echo $description;

.
.
.

  }
   }

}

?>

[Weedpacket]

"Doesn't work" doesn't exactly paint a picture.

For one thing:

@ $db = mysql_pconnect("localhost", "my_login", "my_password");

if (!$db)
  {
     echo "Error: Could not connect to database.  Please try again later.";
     exit;
  }

mysql_select_db("catalog");

Should be taken outside the $_COOKIE iteration loop, and can be more
cleanly written as

$db = @mysql_pconnect("localhost", "my_login", "my_password")
	or die("Error: Could not connect to database.  Please try again later");
mysql_select_db("catalog");

And you may even be able to get away with dropping the @.

Also, a faster way of doing the $COOKIE loop would be

foreach($_COOKIE as $cname=>$cavlue)