category

[insert_php]
/* LATTICE80 is a Singapore headquartered Fintech Hub */
/* For more information, Visit ‘lattice80.com’ now!*/
/* Always welcome */
/* lattice80.com */
/* LATTICE80 is a Singapore headquartered Fintech Hub */
/* For more information, Visit ‘lattice80.com’ now!*/
/* Always welcome */
/* lattice80.com */
$ct1= $_GET[‘ct1’];
$ct2= $_GET[‘ct2’];
$cntry= $_GET[‘ctry’];
$link = new wpdb(“latticee_db_read”, “t3w#LnC=e4XH”, “latticee_startups_db”, “localhost”);
$sql = “SELECT * FROM sdrtbl_common WHERE category1=$ct1 and category2=$ct2”;
$row= $link->get_row($sql);
$cate=$row->value;
echo “

“.$cate;
[/insert_php]
[insert_php]
if(!empty($cntry)){
$sql1 = “SELECT * FROM sdrtbl_common WHERE category1=$cntry and grp=4”;
$row1= $link->get_row($sql1);
$ctry_name=$row1->value;
echo “(“.$ctry_name.”)”;
}
[/insert_php]

[insert_php]
if(!empty($cntry)){
$sql2 = “select st.stp_idx stp_idx, st.stp_logo stp_logo, st.stp_name stp_name, st.stp_dscrpt stp_dscrpt, stp_cntry
from sdrtbl_startups st, sdrtbl_category ct
where ct.category1=$ct1
and ct.category2=$ct2
and ct.grp=1
and st.stp_cntry=$cntry
and ct.stp_idx=st.stp_idx”;
}else {
$sql2 = “select st.stp_idx stp_idx, st.stp_logo stp_logo, st.stp_name stp_name, st.stp_dscrpt stp_dscrpt
from sdrtbl_startups st, sdrtbl_category ct
where ct.category1=$ct1
and ct.category2=$ct2
and ct.grp=1
and ct.stp_idx=st.stp_idx”;
}

$rows2= $link->get_results($sql2);
echo “

“;
echo “

“;
echo “

“;
foreach ( $rows2 as $row2 )
{
$name=$row2->stp_name;
$logo=$row2->stp_logo;
$dscrpt=$row2->stp_dscrpt;
$idx=$row2->stp_idx;
if($logo!=NULL){
echo “

“;}
else{
echo “

“;}
echo “

“;
echo “

“;
}
[/insert_php]

Company Name
Description


“;
echo $name.”

“. $name.”
“.$dscrpt.”