Are there times MySQL queries work differently in MySQLi ?
For instance, this query:
SELECT * FROM inv_task WHERE inv_task.tsk_type = 4 AND inv_task.tsk_date BETWEEN '2014-1-1' AND '2017-1-1'
Fails on a web page but works in PHPmyAdmin
<?php
$Records = new WA_MySQLi_RS("Records",$Domains_i,0);
$Records->setQuery("SELECT * FROM inv_task WHERE inv_task.tsk_type = ? AND inv_task.tsk_date BETWEEN '?' AND '?'");
$Records->bindParam("i", "".$_POST['selinvoiceType'] ."", "4"); //target
$Records->bindParam("i", "".$_POST['selYear'] ."", "2015-1-1"); //targetYear
$Records->bindParam("i", "".$_POST['selYear2'] ."", "2016-1-1"); //targetYear2
$Records->execute();
?>
<body>
<!-- InstanceBeginEditable name="pageName" -->Tax Reporting<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="contentArea" -->
<h2>Business Purchases -</h2>
<p><br />
Invoice Type:
<?php echo($Records->getColumnVal("tsk_type")); ?>
<form name="form1" method="post" action="">
Type: <select name="selinvoiceType" id="selinvoiceType" onchange="this.form.submit();">
<option value=''>-- Please select --</option>
<?php
while(!$Types->atEnd()) { //dyn select
?>
<option value="<?php echo($Types->getColumnVal("tID")); ?>"<?php if (!(strcmp($Types->getColumnVal("tID"), ($Records->getColumnVal("tsk_type"))))) {echo "selected=\"selected\"";} ?>><?php echo($Types->getColumnVal("typeName")); ?></option>
<?php
$Types->moveNext();
} //dyn select
$Types->moveFirst();
?>
</select>
Year:
<select name="selYear" id="selYear" onchange="this.form.submit();">
<option value=''>-- Please select --</option>
<option value="2014-1-1" <?php if ($_POST['selYear']== '2014-1-1'){echo "selected=\"selected\"";} ?>>2014</option>
<option value="2015-1-1" <?php if ($_POST['selYear']== '2015-1-1'){echo "selected=\"selected\"";} ?>>2015</option>
<option value="2016-1-1" <?php if ($_POST['selYear']== '2016-1-1'){echo "selected=\"selected\"";} ?>>2016</option>
<option value="2017-1-1" <?php if ($_POST['selYear']== '2017-1-1'){echo "selected=\"selected\"";} ?>>2017</option>
<option value="2018-1-1" <?php if ($_POST['selYear']== '2018-1-1'){echo "selected=\"selected\"";} ?>>2018</option>
</select>
<select name="selYear2" id="selYear2" onchange="this.form.submit();">
<option value=''>-- Please select --</option>
<option value="2015-1-1" <?php if ($_POST['selYear2']== '2015-1-1'){echo "selected=\"selected\"";} ?>>2015</option>
<option value="2016-1-1" <?php if ($_POST['selYear2']== '2016-1-1'){echo "selected=\"selected\"";} ?>>2016</option>
<option value="2017-1-1" <?php if ($_POST['selYear2']== '2017-1-1'){echo "selected=\"selected\"";} ?>>2017</option>
<option value="2018-1-1" <?php if ($_POST['selYear2']== '2018-1-1'){echo "selected=\"selected\"";} ?>>2017</option>
<option value="2019-1-1" <?php if ($_POST['selYear2']== '2019-1-1'){echo "selected=\"selected\"";} ?>>2019</option>
</select>
</form>
<p>
<?php
while(!$Records->atEnd()) {
?>
$<?php echo number_format($Records->getColumnVal("tsk_value"), $decimals = 2 , $dec_point = '.' , $thousands_sep = ',' ); ?> - <?php echo($Records->getColumnVal("tsk_service")); ?> - <?php echo($Records->getColumnVal("tsk_date")); ?><br />
<?php
$Records->moveNext();
}
$Records->moveFirst(); //return RS to first record
?>
</p>
<p> </p>
<!-- InstanceEndEditable -->
</body>
