Hi. I am trying to pass a variable from one script to another, and am quite stuck. The first script is calling data from one table, and the second from another. The variable in the first script is $col_value[8], which includes data that should be equivalent to the variable in the second script, which right now says "Omoo". If I hard code the name in like that, it works fine. But I have tried $col_value[8] as the variable in the second script in place of Omoo, and the popup window is just blank. Not a query failure, but I get no data from the database. Ideas? Thanks.
}else if ($varcount == 8) {
print "<td>";
print "<font face='Verdana' size='1'><a href=\"javascript<img src="images/smilies/redface.gif" border="0" alt="">penWindow('window.php?action=viewwarranty2&view=$col_value[8]')\">$col_value[8]</a><br></font>";
print "</td>";
-------------------------------------------------
and this is from the second script (window.php)
}else if (($action == "viewwarranty2")) {
$query = "SELECT warranty_comment,aw_tag FROM warranty WHERE warranty_comment='Omoo'";
$result = mysql_query($query) or die("Query faiiled");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$fname = $row["warranty_comment"];
$trimmed = trim($fname);
$fname1 = $row["aw_tag"];
$trimmed = trim($fname1);
print " yadda yadda etc.