Dear Ray
Please give me an example of a query as like below;
<?php
$mainHadith = new WA_MySQLi_RS("mainHadith",$hadithbd,10);
$mainHadith->setQuery("SELECT hadithmain.HadithID, hadithmain.CheckStatus, hadithmain.BookID, hadithmain.chapterID, hadithmain.SectionID, hadithmain.HadithNo, hadithmain.ArabicHadith, hadithmain.ArabicHadithNew, hadithmain.BanglaHadith, hadithmain.EnglishHadith, hadithmain.HadithNote, hadithmain.HadithActive, hadithmain.HadithStatus, hadithbook.totalHadith, hadithbook.BookNameBD, hadithchapter.ChapterBG, hadithchapter.ChapterAR, hadithchapter.ChapterEN, hadithexplanation.explanation, hadithsource.SourceNameBD, hadithsource.SourceNameEN, hadithstatus.StatusBG, rabihadith.rabiBangla, rabihadith.rabiEnglish, hadithsection.SectionBD, hadithsection.SectionEN FROM hadithmain LEFT OUTER JOIN hadithbook ON hadithmain.BookID = hadithbook.BookID LEFT OUTER JOIN hadithchapter ON hadithmain.chapterID = hadithchapter.chapID LEFT OUTER JOIN hadithexplanation ON hadithmain.HadithID = hadithexplanation.hadithID LEFT OUTER JOIN hadithsource ON hadithmain.SourceID = hadithsource.SourceID LEFT OUTER JOIN hadithstatus ON hadithmain.HadithStatus = hadithstatus.StatusID LEFT OUTER JOIN rabihadith ON hadithmain.RabiID = rabihadith.rabiID LEFT OUTER JOIN hadithsection ON hadithmain.SectionID = hadithsection.SectionID WHERE hadithmain.HadithActive = 1 AND hadithmain.HadithNo = ? HAVING hadithmain.BookID = ? ORDER BY hadithmain.HadithNo ASC");
$mainHadith->bindParam("i", "".(isset($_GET['hadith'])?$_GET['hadith']:"") ."", "-1"); //WAQB_Param1
$mainHadith->bindParam("i", "".(isset($_GET['book'])?$_GET['book']:"") ."", "-1"); //WAQB_Param2
$mainHadith->execute();
?>
Here I need to filter the hadithmain.HadithNo by passing a GET value called $mainHadith->bindParam("i", "".(isset($_GET['hadith'])?$_GET['hadith']:"") ."", "-1"); //WAQB_Param1
I need to send search query like index.php?hadith=1,5,10 etc
And in another search I need to get result of in between value from the same filed of hadithmain.HadithNo
Thanks in advance