Simple MySQLi search no longer working despite matching records in table?
So this has just stopped working, for no reason...
The form:
<form action="search-competitions.php" method="post" name="SEARCHCOMPSform" id="SEARCHCOMPSform" class="form-inline">
<div class="form-group">
<label class="sr-only" for="SEARCHcomps">Search</label>
<input type="text" class="form-control" id="SEARCHcomps" name="SEARCHcomps" required>
</div>
<button type="submit" class="btn btn-warning" id="SEARCHCOMPSbtn" name="SEARCHCOMPSbtn">Search <i class="fa fa-search" aria-hidden="true"></i></button>
</form>
The MySQLI@
<?php
$rsSEARCHCOMPS = new WA_MySQLi_RS("rsSEARCHCOMPS",$csdbmysqli,0);
$rsSEARCHCOMPS->setQuery("SELECT dreamcarCOMPID, dreamcarCOMPDATESTART, dreamcarCOMPDATEND, dreamcarCOMPTITLE, dreamcarCOMPSUMMARY, dreamcarCOMPTEXT, dreamcarCOMPIMG, dreamcarCOMPJUDGE1, dreamcarCOMPJUDGE2, dreamcarCOMPJUDGE3, dreamcarCOMPDATEJUDGED, dreamcarCOMPWINNERID, dreamcarCOMPWINNERCARID, dreamcarCOMPDELETE FROM dreamcarCOMPS WHERE dreamcarCOMPDELETE = 2 AND (dreamcarCOMPTITLE LIKE ? OR dreamcarCOMPSUMMARY LIKE ?) ORDER BY dreamcarCOMPDATEND ASC");
$rsSEARCHCOMPS->bindParam("c", "".(isset($_POST['SEARCHcomps'])?$_POST['SEARCHcomps']:"") ."", "-1"); //colname
$rsSEARCHCOMPS->bindParam("c", "".(isset($_POST['SEARCHcomps'])?$_POST['SEARCHcomps']:"") ."", "-1"); //colname1
$rsSEARCHCOMPS->execute();
?>
The dreamcarCOMPDELETE value in the record in the table is 2 and both dreamcarCOMPTITLE and dreamcarCOMPSUMMARY have values in them - "Spot the Ball" and "Using your judgement, place a marker where you think the centre of the ball should be." yet if you type a single letter from any of those phrases no matches are shown?
No idea what's going on. :(
This was working previously and I've not edited any part of it.
Hope you can help. Thank you.
NJ
EDIT: Jayzus! Found it. Wood for the trees again. :(
