navigational problem

madhavr

i have something to the similar problem below....

imagine a table of clients

one of the columns is called status which is a boolean 0 or 1

1 indicates an inactive client

now i have an index page showing two lists one with all the active clients and one with the inactive clients

problem is when i click into say the first active client i dont know how to ensure the navigation buttons so that the next record is definitely an active client rather than inactive since remember they are all stored in the same table.

the way i have done the navigation is that the clientID is incremented but unfortunately this could take me to an inactive client.

the same goes for inactive clients since when scrolling here i dont want to see any active clients.

hope that makes sense

give me the simplest solution you can think of. thanks very much

kevinsequeira

just run the query to filter out the clients based on active or inactive and display

$query_active = "select from clients where status = 0";
$query_inactive = "select from clients where status = 1";

reg
kevin

madhavr

how will the system know which query is appropriate??

to illustrate the problem assume i am navigating a page which is clientID 30

i click the next client button taking me to clientID 31 but this client is inactive

the system wont know that it should ideally skip this client and take me to clientID 32 who is the next active client.

i hope that makes more sense

im not sure how the query thing you said would work with the navigational buttons

if it does then please explain to me how because im new to this

thanks very much

madhavr

im not entirely sure but is the solution to store the active clients in the one table and the inactive clients in another?

this problem would seem to make life much easier i suppose.

however another problem could arise : how can we tell the 'next record' button that the next active client is say 5 records away because the ones in between were all cancelled.

more precisely we are on clientID number 47.

clientIDs 48,49,50,51 are cancelled and are therefore not present in this table since this table only holds actives.

the next clientID is client ID 52 so when i press the 'next button' i should jump from viewing clientID 47 to 52.

i guess this is really the same problem regardless of whichever table i choose to put the inactive/active records. but im trying to figure out a simple and effective solution to this.

please help if you have any suggestions. thank you.

kevinsequeira

post your code
reg
kevin

madhavr

I managed to figure it out

thanks very much

😃