egghelp.org community

[Rolet]

hey i made this code for my ircd network but it seems the loop wont work, it will show one user but if 2 users have the same ip it wont, any help would be greatful, code below

[nml375]

Since you are using lists, have you considered using a foreach-loop? Saves you the hazzle of manually retrieving the row item for each iteration.

I am somewhat puzzled by why you use index $i rather than index 0 in your second query. Being separate tables, there is no way of guaranteeing the same ordering, especially without any sorting directive.
In fact, I would suggest you do a (sql)join instead, which would actually save you one query along with having all the info available at once.

That would be done something like below, edit to suite your needs. If needed, use some sql-client to verify the output of the query.