search with mysql works, but not when converted to mysqli - IGNORE- FIXED!!
This post has been deleted.
This post has been deleted.
I think it needs to be:
<?php
$rsResults = new WA_MySQLi_RS("rsResults",$connRoSite_i,1);
$rsResults->setQuery("SELECT PgID, PgMainPic, PgMainPicAltText, PgTitle, PgDesc, MemOnly, DATE_FORMAT (pages.EvStDate,'%H.%i') AS EvStartTime, DATE_FORMAT (pages.EvStDate,'%a %D %M %Y') AS `StartDate`, pages.SiteID FROM pages WHERE SiteID = ? and pages.PgActive = 'Y' AND( PgTitle LIKE ? OR PgDesc LIKE ? OR PgDetails LIKE ?) ORDER BY pages.ModifiedDate DESC");
$rsResults->bindParam("i", "".$_GET['SiteID'] ."", "-1"); //p1
$rsResults->bindParam("c", "".$_POST['fmSearch'] ."", "%"); //p2
$rsResults->bindParam("c", "".$_POST['fmSearch'] ."", "%"); //p3
$rsResults->bindParam("c", "".$_POST['fmSearch'] ."", "%"); //p4
$rsResults->execute();
?>
You have 4 parameters in your SQL, but it only sent in values for 2 because you had re-used the same one.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.