I have a problem with the hyperlinks..
In my Project i got the data from the database as shown in the images that i have attached.
New_Picture__1_.bmp (396.73K)
Number of downloads: 67
the above image which gives the data from the database with the hyperlinks which i want to show the detailed information..rite...clear..
when I clicked at the Central Zone->No.of Locations = it results an inner page that describes the detailed information as i showed in the image...
New_Picture.bmp (379.04K)
Number of downloads: 65
this above image opens as seperately..(back side previous zones list remain same...
In the above informatin also contains the hyperlinks which shows th in detailed informations....and this page remains same when i click the CZ07->No.of Locations link then it is replacing the above image and showing this..
New_Picture__2_.bmp (233.95K)
Number of downloads: 66
The problem is that when i close the curent window then previous window shuld be active and if i close this window the pre previous should be active but it is not working... help me
I'm also giving the Code...
for ($i=0; $i < $num_columns; $i++) {
$fields[$i] = $result->Fields($i);
}
$j=0;
$k=0;
$cat ="";
$cat1="";
$cat2="";
$cat3="";
$cat4="";
$cat5="";
$cat6="";
$cat7="";
$cat8="";
$cat9="";
while (!$result->EOF) //carry on looping through while there are records
{
$cat = $cat.$fields[0].':';
$cat1 = $cat1.$fields[1].':';
$cat2 = $cat2.$fields[2].':';
$cat3 = $cat3.$fields[3].':';
$cat4 = $cat4.$fields[4].':';
if( $fields[5] =! null)
{
$cat5 = $cat5.$fields[5].':';
}
else
{
$cat5 = ".':'";
}
if( $fields[6] =! null)
{
$cat6 = $cat6.$fields[6].':';
}
else
{
$cat6 = ".':'";
}
if( $fields[7] =! null)
{
$cat7 = $cat7.$fields[7].':';
}
else
{
$cat7 = ".':'";
}
if( $fields[8] =! null)
{
$cat8 = $cat8.$fields[8].':';
}
else
{
$cat8 = ".':'";
}
if( $fields[9] =! null)
{
$cat9 = $cat9.$fields[9].':';
}
else
{
$cat9 = ".':'";
}
$circleid = (explode(":",$cat));
$circlename = (explode(":",$cat1));
$housescoverno = (explode(":",$cat2));
$housesnotcoverno = (explode(":",$cat3));
$transname = (explode(":",$cat4));
$locationsno = (explode(":",$cat5));
$openpointsno = (explode(":",$cat6));
$binpointno = (explode(":",$cat7));
$totalbinsno = (explode(":",$cat8));
$vehiclesno = (explode(":",$cat9));
echo "<tr class='gentext' style='padding-top:2px; padding-bottom:2px;'>";
do
{
$cid = $circleid["$j"];
$cname = $circlename["$j"];
$hoc = $housescoverno["$j"];
$honc = $housesnotcoverno["$j"];
$tname = $transname["$j"];
if( $locationsno = 1)
{
$noloc = "0";
}
else
$noloc = $locationsno["$j"];
if( $openpointsno = 1)
{
$openloc = "0";
}
else
$openloc = $openpointsno["$j"];
if( $binpointno = 1)
{
$binloc = "0";
}
else
$binloc = $binpointno["$j"];
if( $totalbinsno = 1)
{
$nobins = "0";
}
else
$nobins = $totalbinsno["$j"];
if( $vehiclesno = 1)
{
$noveh = "0";
}
else
$noveh = $vehiclesno["$j"];
echo "<td class='gentext' width='120px'>$cid</td>";
echo "<td class='gentext' width='180px'>$cname</td>";
echo "<td class='gentext' width='120px'>$hoc</td>";
echo "<td class='gentext' width='120px'>$honc</td>";
echo "<td class='gentext' width='120px'>$tname</td>";
echo "<td class='gentext' width='120px'><a href='java script:locationinfo_circle_$k()' onfocus='blur();'>$noloc</a></td>";
echo "<td class='gentext' width='160px'><a href='java script:openpointinfo_circle_$k()' onfocus='blur();'>$openloc</a></td>";
echo "<td class='gentext' width='160px'><a href='java script:binpointinfo_circle_$k()' onfocus='blur();'>$binloc</a></td>";
echo "<td class='gentext' width='160px'><a href='java script:bininfo_circle_$k()' onfocus='blur();'>$nobins</a></td>";
echo "<td class='gentext' width='160px'><a href='java script:vehicleinfo_circle_$k()' onfocus='blur();'>$noveh</a></td>";
echo "</tr>\n";
$j++;
$k++;
}while($result->EOF);
$result->MoveNext();
}
$result->Close();
$conn->Close();
$result = null;
$conn = null;
}
else echo "ADODB not connected";

New Topic/Question
Reply




MultiQuote




|