$sql="SELECT p.id, part, p.image AS pimage, v.vid, name, v.image AS vimage FROM products AS p LEFT JOIN vendors AS v ON p.id = v.vid WHERE p.part LIKE '%{$_POST['partno']}%'";