[insert_php]
$vid = $_GET[‘v_id’];
$connArr = explode(‘:’, DB_HOST);
$conn = new mysqli($connArr[0], DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn,”utf8″);
$sql =
“SELECT * FROM vendor_data WHERE is_active = 1 AND is_public <> 1 AND slug = ‘” . $vid . “‘”;

$result = $conn->query($sql);
if ($result->num_rows > 0){
$row = $result->fetch_assoc();
}
[/insert_php]

margin-bottom: 10px;”>Click Here to find out how well this vendor aligns with your needs

[insert_php]if ($result->num_rows == 0){ echo ‘

Sorry, Vendor not found

‘; } else{ echo’'.$row['name'].'‘; }[/insert_php]

 

Founded [insert_php]echo $row[‘established_date’];[/insert_php]
[insert_php]echo $row[‘location’];[/insert_php]

Lives Serviced Annually: This information is only available to authorized Shortlister users

 .

Group Sizes Serviced: This information is only available to authorized Shortlister users

 

Programs Offered

[insert_php]
$sql2 =
“SELECT * FROM vendor_programs WHERE vendor_id = ” . $row[‘vendor_id’] . ” ORDER BY program_name”;

$result2 = $conn->query($sql2);
if ($result2->num_rows > 0){
echo ‘

‘;
$r = 0;
while($row2 = $result2->fetch_assoc()){
if ($r % 10 == 0){
if ($r == 0){
echo ‘

    • ‘;
    • }
    • else{
    echo ‘
    • ‘;
    • }
    • }

echo “

    • “.$row2[‘program_name’].”

“;
$r++;
}
echo ‘

‘;
echo ‘

‘;
}
else{
echo ‘

‘;
}
[/insert_php]

[insert_php]
if (($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) || ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL” && $row[‘snapshot2_visibility’] != 1) || ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL” && $row[‘snapshot3_visibility’] != 1) || ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) || ($row[‘media2_link’] && $row[‘media2_link’] != “NULL” && $row[‘media2_visibility’] != 1) || ($row[‘media3_link’] && $row[‘media3_link’] != “NULL” && $row[‘media3_visibility’] != 1)){
if ($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1){ echo ‘‘; }
if ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL” && $row[‘snapshot2_visibility’] != 1){ echo ‘‘; }
if ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL” && $row[‘snapshot3_visibility’] != 1){ echo ‘‘; }
if ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1){
if ($row[‘media1_type’] == 0) {
echo ‘‘;
}
else{
echo ‘‘;
}
}
if ($row[‘media2_link’] && $row[‘media2_link’] != “NULL” && $row[‘media2_visibility’] != 1){
if ($row[‘media2_type’] == 0) {
echo ‘‘;
}
else{
echo ‘‘;
}
}
if ($row[‘media3_link’] && $row[‘media3_link’] != “NULL” && $row[‘media3_visibility’] != 1){
if ($row[‘media3_type’] == 0) {
echo ‘‘;
}
else{
echo ‘‘;
}
}
echo ‘
‘;
}
else{
echo “No Media uploaded for this vendor.”;
}
[/insert_php]


You must be a registered user of Shortlister to access this information
Click here to verify your identity and continue searching.

MORE INFORMATION

GOES RIGHT HERE


You must be a registered user of Shortlister to access this information
Click here to verify your identity and continue searching.


You must be a registered user of Shortlister to access this information
Click here to verify your identity and continue searching.

[insert_php]echo $row[‘name’];[/insert_php]

[insert_php]echo $row[‘summary’];[/insert_php]

Value Proposition

[insert_php]echo $row[‘value_proposition’];[/insert_php]