it is my tblink.php page where i am trying to link a individual colm which should display related symbol details which stored in mysql database for that i written seprate code named as symbol.php
when i click on Symbol in table i am getting only last Symbol name not related Symbol.
tblink.php
PHP Code:
while( $sql_row=mysql_fetch_array($sql_result) ) {
$Symbol=$sql_row["Company"];
echo "<tr >";
echo "<td id=\"comp\" bgcolor=\"#E9E9E9\"><a href=\"#\" onclick=\"javascript:link('symbol.php')\" name=\"symb\" id=\"symb\">".$Symbol."</a></td>";
$_SESSION['symbol'] = $Symbol;
echo "</tr>";
}
echo "</table><br>";
}
?>
Symbol.php
<?php
session_start();
ob_start();
$symbol = $_SESSION['symbol'];
if(isset($_POST))
{
include_once 'db.php';
$sql="call sp_search('".$symbol."')";
$sql_result=mysql_query($sql) or exit("Sql Error".mysql_error());
$sql_num=mysql_num_rows($sql_result);
echo "<table width=\"50\" height=\"50\" border=\"0\" cellspacing=\"0\" cellpadding=\"10\">";
$sql_row = mysql_fetch_array($sql_result);
echo "<tr bgcolor=\"#EBEBEB\">";
echo "<th align=\"left\"> Company Name </th>";
echo "<td align=\"center\">".$sql_row['company']."</td>";
echo "<th align=\"left\"> Vol: </th>";
echo "<td align=\"center\">".$sql_row['value']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th align=\"left\"> Price: </th>";
echo "<td align=\"center\">".$sql_row['price']."</td>";
echo "</tr>";
echo "</tr>";
echo "</table>";
}
?>
Plz sugest as soon as possible its urgent
Last edited by chrishirst; 08-19-2010 at 04:32 PM..
|
