Search & Compare Multiple MySQL Tables -

-

i'm trying use php search ips , ad networks in mysql database. rotate visitors between various ad networks prevent same visitor being sent same network within 24 hour period.

ip_addresses table

id, address, network_id 1, 120.110.140.223, 1 2, 120.110.140.223, 3 3, 115.157.247.46, 1

networks table

id, name, clicks, status, order 1, random name, 200, active, 1 2, example name, 500, inactive, 3 3, other name, 100, active, 2

basically when visitor hits our php page, need able echo specific id networks table. should the id of first network isn't listed in ip_addresses table visitor's ip address. networks should ordered order column , should have status = active.

i thought using php list of id's of networks status set active , correctly ordered this:

select id networks status = 'active' order id asc

and loop through until reach first id isn't in ip_addresses table ip. however, wasn't sure how loop or how make stop once first network_id isn't in ip_addresses table found.

if need clarify anything, please let me know. thanks!

you use not in sub-query passing user's ip

select id networks status = 'active'   , id not in (     select network_id     ip_addresses     address = '$ip' ) order id limit 1;

Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

jsf - "PropertyNotWritableException: Illegal Syntax for Set Operation" error when setting value in bean -

-
this question has answer here: how send form input values , invoke method in jsf bean 1 answer i error when trying send values jsf page bean. i want set values fields in bean, create airplane instance , add database. error telling me use illegal syntax setter part of bean. why error? didnt find on site helped me problem. here jsf part: <h4>add plane</h4> <c:if test="#{not empty listairplanebb.error}"> <div class="alert alert-danger"> <span class="glyphicon glyphicon-remove"></span> <h:outputtext value="#{listairplanebb.error}" /> </div> </c:if> <h:form> <table class="table"> <thead> ...
Read more

C++ Program To Find Smallest and Largest Number In Array -

-
beginner in c++ here , learning arrays. program below supposed return smallest , largest number in array using 2 separate functions. 1 largest , 1 smallest number. however, returning 0 time function lastlowestindex , unsure may doing wrong. could ever kindly advice , show me incorrect in function , can done correct returns correct value? not seeing and/or understanding incorrect. thank , time in advance!!! #include <iostream> #include <cstdlib> int lastlargestindex(int [], int); int lastlowestindex(int [], int ); using namespace std; int main() { const int n = 15; int arr[n] = {5,198,76,9,4,2,15,8,21,34,99,3,6,13,61}; int location; //int location2; location = lastlargestindex( arr, n ); cout << "the last largest number is:" << location << endl; location = lastlowestindex(arr, n); cout << "the last smallest number is:" << location << endl; // std::system ("pause"); ...
Read more