Retrieve related data : Passed to variable to popup.

[facets]

Hi,

I've managed (with some help) to pass a variable to a popup window. now i'm having some troubles retrieving the coinsiding data. I is set WHERE stockId = '2'; I get the data I need, but this is not the right way to do it. Woudl I need to assign a new variable to stockId and used that? Any thoughts?

tks, Will

// View Record Function
function viewFaceStock() {

html_header();

$stockId = $_GET['stockId'];

print_r($_SESSION);
print_r($_POST); 

$query = "SELECT stockId, description, basisWeight, caliper FROM austock WHERE stockId = '$stockId'";

$result = mysql_query($query);

    if(!$result) error_message(sql_error());

$query_data = mysql_fetch_array($result);
$stockId = $query_data["stockId"];

echo $stockId;
echo "<br>";

[facets]

Sorry kats.

I was assigning the stockname to stockId earlier in my code. DOH!