I have two questions here.. How do I modify this code:
<?php
$rsResults = new WA_MySQLi_RS("rsResults",$conn_mdb1,0);
$rsResults->setQuery("SELECT * FROM maintbl WHERE mainID LIKE ? OR firstName LIKE ? OR lastName LIKE ? OR licenseNumber LIKE ? ORDER BY mainID ASC");
$rsResults->bindParam("i", "".(isset($_GET['mainID'])?$_GET['mainID']:"") ."", "-1"); //colname
$rsResults->bindParam("s", "".(isset($_GET['firstName'])?$_GET['firstName']:"") ."", "-1"); //paramNam
$rsResults->bindParam("s", "".(isset($_GET['lastName'])?$_GET['lastName']:"") ."", "-1"); //paramNam
$rsResults->bindParam("s", "".(isset($_GET['licenseNumber'])?$_GET['licenseNumber']:"") ."", "-1"); //paramLic
$rsResults->execute();
?>
so it will find partial matches.. Like say the name was Reddy, searching for Red does not find it.
Secondly - see attached page.
I also have modified this search to use only one search field. I have it working but I wanted to try it without using WA to do it. Just to learn.
All I am trying to figure out is how to format the results from the array. I have it echoing the results to the screen fine but cant figure out how to get it into a formatted table. code on the attached page prints a table but it is one long row not rows/columns.
Would appreciate any input.
Thanks.