Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › MySqli Help

MySqli Help

Thread began 11/10/2014 9:58 am by The Flying Fox | Last modified 11/10/2014 12:47 pm by The Flying Fox | 678 views | 4 replies

11/10/2014 12:32 pmThe Flying Fox

Completed

Hi Jason,

I got there eventually

<?php
$rsTraders = new WA_MySQLi_RS("rsTraders",$admin_chg,0);
$rsTraders->setQuery("SELECT tbl_traders.traderID, tbl_products.ProductDimensions, tbl_traders.approved, tbl_traders.trading_name FROM (tbl_traders LEFT JOIN tbl_pitch_allocation ON tbl_traders.traderID = tbl_pitch_allocation.traderID) LEFT JOIN tbl_products ON tbl_traders.pitch_req = tbl_products.ProductID WHERE tbl_pitch_allocation.traderID Is Null and tbl_traders.approved=1;");
$rsTraders->execute();
?>

Thanks

Andy

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.