$row_cid[$cid_txt]"; if (!isset($show)){ $show=0; } $sql = "select * from $table where cid=$cid order by cno "; $result = mysql_query($sql) or die ("Can't Perform Query1"); if ($result) { $count = mysql_num_rows($result); } //connect database $sql = "select * from $table where cid='$cid' order by cid "; mysql_connect($host,$uid,$pw) or die ("Unalbe to connect to SQL server"); mysql_select_db($db) or die ("Unable to select database"); $result = mysql_query($sql) or die ("Can't Perform Query"); // show data loop echo (""); while($row=mysql_fetch_array($result)){ echo ""; if ($row[4]!=""){ echo ""; } else { echo ""; } echo " "; echo ""; } echo "
$row[$txt1]
$row[$txt2]"; echo "
"; ?>