";
for ($i=0;$i<$nums_rows;$i++)
{
$result = mysql_fetch_array($db_query);
$q_id = $result[q_id];
$q_topic = $result[q_topic];
$q_name = $result[q_name];
$q_email = $result[q_email];
$q_datetime = $result[q_datetime];
$sql1 = "select * from ub_a where a_qid = '$q_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($q_datetime,0,2),substr($q_datetime,2,2),substr($q_datetime,4,2)));
echo " | $q_id |
| $q_topic
- submit by $q_name
$showdate ($num_rows1) | |
";
}
echo "
";
echo "