Passing variable from MYsql to new window

[ihenman]

Well this is probably something simple that is just stumping me but...

I have a page that takes a list of links from a MYsql DB. The links are then opened in a new window in this fashion....

1.) a description of a link is taken from DB and listed in a table
2.) when the link is clicked a new window is opened (window.open) and a script executes to count how many times that particular link has been clicked. Then I use a window.redirect function to change the URL of the new window.

heres where the problem starts... The URL for the new window is stored in the DB with the same row as the description first listed... But how can I pass the url to the new window opened from the first window... (sorry if I'm saying window too much and this is becoming confusing)

I've tried a couple of things... i.e. Javascript mainly but have been unsuccessful to this pt.

Hope someone can help.

I think some of my problem is coming from the fact that I'm not trying to pass a static variable... but I dunno 4 sure.

[lanjoky]

Can you show us some code to maybe help explain the problem a little further??

[hi-liter]

<?php

// page1.php

// get url from db
$URL = "http://www.google.com"; 

echo ("

<a href='page2.php?$URL' target='_new'>Open New window, carry URL to it</a>

");

?>

<?php

// page2.php

$urlPassed = $_SERVER["QUERY_STRING"];

echo ("

$urlPassed

");

?>

[lanjoky]

try using urlenocde to encode the query string for passing it properly here is the php.net manual referance for that function
http://us4.php.net/manual/en/function.urlencode.php

Hope that helps