Dynamic Hyperlinking

[prent327]

I have the following line of code in a table;

<tr><td><a href="http://pscdata.com/Balance/TwoBalance.php?id="><img src="http://pscdata.com/Images/2-years.gif" border="0"></td></tr>

After the ?id= I would like to call up a variable set earlier within the php here, $IDNumber = $_SESSION['IDNumber'];

How do I do this?

[harmor]

Just add it after the equal sign

<a href="http://pscdata.com/Balance/TwoBalance.php?id=$IDNumber">

[prent327]

I tried that already, but it doesn't work. Let me post a little more of my file.

Here's all of the session and php code before the hyperlink.

<?php
session_start();
header("Cache-control: private");
if (isset($_POST['company']) || isset($_GET['company'])){
  $Company = (isset($_POST['company']))? $_POST['company']:$_GET['company'];
} 
?>

HTML that contains the submit forms for "company" and "ticker"

<?php
if(isset($_SESSION['IDNumber']) && (!isset($_POST['Ticker']) || !isset($Company))) {
    $IDNumber = $_SESSION['IDNumber'];
}
else {
    $IDNumber = "";
    $Ticker = $_POST['Ticker'];
    $Company = $Company;
}
$db = mysql_connect('host', 'username', 'password') or die("Error - cound not connect to server");
$er = mysql_select_db('prent32_FinDat') or die("Error - cound not connect to database");

if (isset($_POST['Ticker']) || !isset($Company) && $IDNumber=="") {
      $q = "SELECT * FROM General WHERE Ticker = '$Ticker' or Company = '$Company'";
$result = mysql_query($q) or die(mysql_error());
}
else if ($IDNumber!="") {
      $q = "SELECT * FROM General WHERE Ticker = '$Ticker' or Company = '$Company'";
$result = mysql_query($q) or die(mysql_error());
}

$num_rows = mysql_num_rows($result);

if ($num_rows <=0)

?>

And then comes the hyperlink as I have it currently,
<tr><td><a href="http://pscdata.com/Balance/TwoBalance.php?id=".urlencode($IDNumber)."\"><img src="http://pscdata.com/Images/2-years.gif" border="0"></td></tr>

[harmor]

echo $IDNumber after it's been set and see if it's working.

[prent327]

echo it after it's been set in the hyperlink? I know that it's not working because the url that shows up when scrolling over it is just, http://pscdata.com/Balance/TwoBalance.php?id=

[harmor]

Change

if(isset($_SESSION['IDNumber']) && (!isset($_POST['Ticker']) || !isset($Company))) {
    $IDNumber = $_SESSION['IDNumber'];
} 

To

if(isset($_SESSION['IDNumber']) && (!isset($_POST['Ticker']) || !isset($Company))) {
    $IDNumber = $_SESSION['IDNumber'];

echo $IDNumber;
} 

[prent327]

Ok, I did that, but the URL that the hyperlink shows is still empty at the end.

[harmor]

Forget about the URL for the moment.

If the id number does not displays on your page then there is something wrong with your code.

[prent327]

No IDNumber shows up on the page, but I have an entire table of information that shows up later in the code that corresponds to the IDNumber, so it seems like it's working.