$total1_result = dbquery("SELECT * FROM ".DB_HOME_BOOK." WHERE owner_id='".$userdata['user_id']."'");
$num_rows = dbrows($total1_result);
$query = $search;
$sum = 0; THIS IS NEW
$result = dbquery("SELECT * FROM ".DB_HOME_BOOK." WHERE owner_id='".$userdata['user_id']."' AND title LIKE '%$query%' OR author LIKE '%$query%' OR format LIKE '%$query%' OR publisher LIKE '%$query%' OR year LIKE '%$query%' OR isbn LIKE '%$query%' OR value LIKE '%$query%'");
$nrows = dbrows($result);
$sum += (intval($nrows['value'])); THIS IS NEW AND THE SOURCE OF THE ERROR
if ($nrows) {
opentable($locale['his_1400']);
MenuBook();
echo "<br /><div align='center'><b>".$locale['his_1403']."<span style='background-color:#ffff88;color:#333;font-weight:bold;padding-left:2px;padding-right:2px'>$query</span>".$locale['his_1404']."</b></div><br>";
BELOW CODE IS NEW
echo "<table align='center'><tr><td height='3' colspan='3'></td></tr>\n";
$formatted_value = "$".number_format( (float) $sum, 2, '.', '');
echo "<tr><td class='srch-total' align='center'>".$locale['his_1433']."$num_rows</td><td class='srch-total' align='center'>".$locale['his_1425']."$nrows</td><td class='srch-total' align='center'>".$locale['his_1424']."$formatted_value</td></tr>\n";
echo "<tr><td height='3' colspan='3'></td></tr></table>\n";
if
statement to get rid of error
if ($nrows) {
$sum += (intval($nrows['value'])); THIS IS NEW AND THE SOURCE OF THE ERROR
$sum += (intval($nrows['value'])); THIS IS NEW AND THE SOURCE OF THE ERROR
if ($nrows) {
if (!EMPTY($nrows['value']) && $nrows['value'] != 0) {
$sum += (intval($nrows['value'])); THIS IS NEW AND THE SOURCE OF THE ERROR
Category Forum
Modifications and Requests - 9Labels
Statistics
3 participants
Notifications
You are not receiving notifications from this thread.
Related Questions