| Manufacturers List for Contact Registration
|
Help
|
Error retrieving data from Manufacturers List.
" . "Error: ". mysql_error(). " |
");
}
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
echo("
| No Manufacturer Contacts Registered |
");
}else{
while ($row = mysql_fetch_array($listem)) {
$mid_array[] = $row['MID'];
}
$mid_array_unique = array_unique($mid_array);
foreach($mid_array_unique as $value){
echo("
");
$listemb = @mysql_query("SELECT CID FROM mfg_con WHERE MID='$value'");
if (!$listemb) {
echo("
Error retrieving Contacts from $value List.
" . "Error: ". mysql_error(). " |
");
}
$num_rowsb = mysql_num_rows($listemb);
if($num_rowsb < 1){
echo("
| No Contacts Registered to $value |
");
}else{
while ($rowb = mysql_fetch_array($listemb)) {
$cid_array[] = $rowb['CID'];
}
}
mysql_select_db('ecosmar_contacts', $dbcnx);
foreach($cid_array as $valueb){
$listemc = @mysql_query("SELECT ID,first_Name,Name,usrn FROM con_main WHERE ID='$valueb'");
if (!$listemc) {
echo("
Error retrieving Contacts
" . "Error: ". mysql_error(). " |
");
}else{
$rowc = mysql_fetch_array($listemc);
$id_array[] = $rowc['ID'];
$fname_array[] = $rowc['first_Name'];
$name_array[] = $rowc['Name'];
$usrn_array[] = $rowc['usrn'];
}
}
$name_sort = natsort($name_array);
foreach ($name_sort as $key=>$value) {
echo("
");
}
}
?>
" .
"
" .
"