";
for ($i=0;$i<$nums_rows;$i++)
{
$result = mysql_fetch_array($db_query);
$p_id = $result[p_id];
$p_name = $result[p_name];
$p_email = $result[p_email];
$p_detail = $result[p_detail];
$p_subject = $result[p_subject];
$p_filename = $result[p_filename];
$p_point = $result[p_point];
$p_date = $result[p_date];
$a_id = $result[a_id];
$sql1 = "select * from picstock where p_id = '$p_id'";
$db_query1 = mysql_db_query ($dbname, $sql1);
$num_rows1 = mysql_num_rows($db_query1);
$showdate = date("F j, Y", mktime(0,0,0,substr($p_date,0,2),substr($p_date,2,2),substr($p_date,4,2)));
echo " | $p_id |
| $p_subject
- submit by $p_name
$showdate ($num_rows1) | |
";
}
echo "
";
echo "