i have query uses or , and @ same time. using pdo.
$conn = new pdo('mysql:host=localhost;dbname=helpinghands', 'root', ''); $table = $conn->query("select a1.nickname lv1_1, a2.nickname lv1_2, a3.nickname lv1_3, a4.nickname lv1_4, a5.nickname lv1_5, a6.nickname lv1_6, a7.nickname lv1_7, a8.nickname lv1_8, a9.nickname lv2_1, a10.nickname lv2_2, a11.nickname lv2_3, a12.nickname lv2_4, a13.nickname lv3_1, a14.nickname lv3_2, a15.nickname lv4 tables t left join accounts a1 on t.l1_1=a1.sponsorid left join accounts a2 on t.l1_2=a2.sponsorid left join accounts a3 on t.l1_3=a3.sponsorid left join accounts a4 on t.l1_4=a4.sponsorid left join accounts a5 on t.l1_5=a5.sponsorid left join accounts a6 on t.l1_6=a6.sponsorid left join accounts a7 on t.l1_7=a7.sponsorid left join accounts a8 on t.l1_8=a8.sponsorid left join accounts a9 on t.l2_1=a9.sponsorid left join accounts a10 on t.l2_2=a10.sponsorid left join accounts a11 on t.l2_3=a11.sponsorid left join accounts a12 on t.l2_4=a12.sponsorid left join accounts a13 on t.l3_1=a13.sponsorid left join accounts a14 on t.l3_2=a14.sponsorid left join accounts a15 on t.l4=a15.sponsorid (t.l1_1 = " . $conn->quote($session->sponsorid) . " or t.l1_2 = " . $conn->quote($session->sponsorid) . " or t.l1_3 = " . $conn->quote($session->sponsorid) . " or t.l1_4 = " . $conn->quote($session->sponsorid) . " or t.l1_5 = " . $conn->quote($session->sponsorid) . " or t.l1_6 = " . $conn->quote($session->sponsorid) . " or t.l1_7 = " . $conn->quote($session->sponsorid) . " or t.l1_8 = " . $conn->quote($session->sponsorid) . " or t.l2_1 = " . $conn->quote($session->sponsorid) . " or t.l2_2 = " . $conn->quote($session->sponsorid) . " or t.l2_3 = " . $conn->quote($session->sponsorid) . " or t.l2_4 = " . $conn->quote($session->sponsorid) . " or t.l3_1 = " . $conn->quote($session->sponsorid) . " or t.l3_2 = " . $conn->quote($session->sponsorid) . " or t.l4 = " . $conn->quote($session->sponsorid) . ") , status = '1' "); if and status = '1' not there, working. need query status field can output specific field. how can accomplish that? thank in advance.
// try $conn = new pdo('mysql:host=localhost;dbname=helpinghands', 'root', ''); $table = $conn->query("select a1.nickname lv1_1, a2.nickname lv1_2, a3.nickname lv1_3, a4.nickname lv1_4, a5.nickname lv1_5, a6.nickname lv1_6, a7.nickname lv1_7, a8.nickname lv1_8, a9.nickname lv2_1, a10.nickname lv2_2, a11.nickname lv2_3, a12.nickname lv2_4, a13.nickname lv3_1, a14.nickname lv3_2, a15.nickname lv4 tables t left join accounts a1 on t.l1_1=a1.sponsorid left join accounts a2 on t.l1_2=a2.sponsorid left join accounts a3 on t.l1_3=a3.sponsorid left join accounts a4 on t.l1_4=a4.sponsorid left join accounts a5 on t.l1_5=a5.sponsorid left join accounts a6 on t.l1_6=a6.sponsorid left join accounts a7 on t.l1_7=a7.sponsorid left join accounts a8 on t.l1_8=a8.sponsorid left join accounts a9 on t.l2_1=a9.sponsorid left join accounts a10 on t.l2_2=a10.sponsorid left join accounts a11 on t.l2_3=a11.sponsorid left join accounts a12 on t.l2_4=a12.sponsorid left join accounts a13 on t.l3_1=a13.sponsorid left join accounts a14 on t.l3_2=a14.sponsorid left join accounts a15 on t.l4=a15.sponsorid (t.l1_1 = " . $conn->quote($session->sponsorid) . " or t.l1_2 = " . $conn->quote($session->sponsorid) . " or t.l1_3 = " . $conn->quote($session->sponsorid) . " or t.l1_4 = " . $conn->quote($session->sponsorid) . " or t.l1_5 = " . $conn->quote($session->sponsorid) . " or t.l1_6 = " . $conn->quote($session->sponsorid) . " or t.l1_7 = " . $conn->quote($session->sponsorid) . " or t.l1_8 = " . $conn->quote($session->sponsorid) . " or t.l2_1 = " . $conn->quote($session->sponsorid) . " or t.l2_2 = " . $conn->quote($session->sponsorid) . " or t.l2_3 = " . $conn->quote($session->sponsorid) . " or t.l2_4 = " . $conn->quote($session->sponsorid) . " or t.l3_1 = " . $conn->quote($session->sponsorid) . " or t.l3_2 = " . $conn->quote($session->sponsorid) . " or t.l4 = " . $conn->quote($session->sponsorid) . ") , t.status = '1' "); 
Comments
Post a Comment