";
if ($var_VendorID)
{
$sql = "
SELECT *
FROM tb_ListCompany
WHERE col_ListCompanyID = $var_VendorID
AND col_ListCompanyRcdExpiry is null
";
if($result = mysql_query($sql,$db))
while ($myrow = mysql_fetch_array($result))
{
echo "
";
$sql = "
SELECT col_ListCompanyOID,
col_CompanyName
FROM tb_ListCompany
WHERE (col_Centre ='' OR col_Centre is null)
AND col_ListCompanyRcdExpiry is null
ORDER BY col_CompanyName
";
if($result = mysql_query($sql,$db))
while ($myrow = mysql_fetch_array($result))
{
if(!$myrow["col_CompanyName"])
continue;
$str_format = "