Getting blank when hyperlinking in PHP

[hbhaskar]

I used the following command to hyperlink

$result_id1 = mysql_query("SELECT * FROM query order by case_id");
for ($i=0; $row1=mysql_fetch_array($result_id1); $i++)
{
//case_no is a field in the table "query"
echo "<TD><b><a href='http://localhost/test/details.php?case=$row1[case_no]'> $row1[case_no]</a></b> </TD>";
}

now the file details.php is something like:

$case= $_REQUEST['case'];
// after the connection and all
$result_new = mysql_query("SELECT * FROM query WHERE case_no = '$case'") or die ("Error: ".mysql_error());
$row=mysql_fetch_array($result_new);

After i do this, I am getting a blank when i try to display a field of the table "date_rec"

echo $row[date_rec];

please help me out asap...

[dgreenhouse]

I don't see where you've referenced "date_rec" anywhere in your code.

The following creates a valid link:

$row1['case_no'] = "hello";

echo "<TD><b><a href='http://localhost/test/details.php?case=$row1[case_no]'> $row1[case_no]</a></b> </TD>";

[hbhaskar]

see "case_id","case _no" and "date_rec" are the fields in the table "query"

[deric]

Try this...

echo $row["date_rec"];

http://php.net/manual/en/function.mysql-fetch-array.php