exit; } else { $mysms = new sms(); if ($mysms->session) { $Charge = $mysms->checkCoverage($CountryCode . $AreaCode . $Number); } echo "Saving...."; $f->save_values(); $count = 0; $db->query("select distinct Country from SmsCoverage where CountryCode='" . $CountryCode . "'"); echo "<b>Done!</b><br><table><tr><td><b>Carriers in "; while ($db->next_record()) { if ($count) { echo ", "; } echo $db->f("Country"); $count++; } $MobileNumber = $CountryCode . $AreaCode . $Number; echo " </b></td><td><b>Credits Used Per SMS Message</b></td></tr>\n"; $db->query("select * from SmsCoverage where CountryCode='" . $CountryCode . "'"); while ($db->next_record()) { printf("<tr><td>%s</td><td>%s</td></tr>\n", $db->f("Carrier"), $db->f("Cost")); } echo "</table><br><a href=\"" . $sess->self_url() . "\">Back to SmsAddressBook.</a><br>\n"; echo "<a href=" . $sess->self_url(); echo $sess->add_query(array("submit" => "Send VCard", "MobileNumber" => $MobileNumber, "Recip" => $Name)); echo ">Send VCard to " . $Name . "</a>"; page_close(); exit; }
$q->start_row = $startingwith; $q->row_count = $rowcount; } // When we hit that page a second time, the array named // by $base will be set and we must generate the $query. // Ah, and don\'t set $base to "q" when $q is your Sql_Query // object... :-) if (isset($x)) { $query = $q->where("x", 1); } if (!$query) { $query = "id!='0'"; } $db->query("SELECT COUNT(*) as total from SmsLog where " . $query); $db->next_record(); if ($db->f("total") < $q->start_row - $q->row_count) { $q->start_row = $db->f("total") - $q->row_count; } if ($q->start_row < 0) { $q->start_row = 0; } if (!$sortorder) { $sortorder = "id"; } $query .= " Order By " . $sortorder . " LIMIT " . $q->start_row . "," . $q->row_count; // In any case we must display that form now. Note that the // "x" here and in the call to $q->where must match. // Tag everything as a CSS "query" class. printf($q->form("x", $t->map_cols, "query")); printf("<hr>"); // if (!$query) { $query="id!='0'"; }