Hi all,
Whats wrong here in the first part it showing value of rows but in the second part it is displaying zero number of rows, ........its displaying 0 for this statement... echo $sentid1;
<?php
session_start();
include('database.php');
$result = mysql_query("SELECT * FROM autoalto_contractor_sentitems" );
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td width="10%"></td>
<td >
<?echo $row['to_user']?></td>
<td >
<a href="contractor_sent_itmes.php?sentid=<? echo $row['sent_id'];
?>">
<?
session_start();
include('database.php');
$sentid1 = $_GET['sent_id'];
echo $sentid1;
$query1="SELECT * FROM autoalto_contractor_sentitems where sent_id='".$sentid1."'" ;
//echo $query1;
$result = mysql_query( $query1 );
echo mysql_num_rows($result) ;
while($row = mysql_fetch_array($result))
{
echo $row['message'];
}
mysql_close();
?>