<?php
        require_once ('config.php');

        $queryResult = mysqli_fetch_assoc(mysqli_query($link, "SELECT * FROM products WHERE pid=1"));

            $cid = $queryResult['cid'];
            $pid = $queryResult['pid'];
                                    $query = mysqli_query($link, "SELECT * FROM `products_fields` WHERE pid=$pid");
                                    $row = mysqli_fetch_assoc($query);
                                    foreach($row as $field => $value)
                                        {
                                            echo $field.' = '.$value.'</br>';
                                        }

?>