Little question with MySQL and multiple rows - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Little question with MySQL and multiple rows (/showthread.php?tid=258762)

---

Little question with MySQL and multiple rows - steki. - 01.06.2011

Well, I'm starting my MySQL ban system and I'd like to know how do I use multiple rows using mysql_num_row.

Thanks (;

@EDIT: I use StrickenKid's

---

Re: Little question with MySQL and multiple rows - Calgon - 01.06.2011

You need to be more specific. The mysql_num_rows function returns an integer of how many rows your [select] query returns.

Example: You have an accounts table with 2 accounts, you execute the query "SELECT * FROM accounts" and it'd return 2 from mysql_num_rows.

---

Re: Little question with MySQL and multiple rows - steki. - 01.06.2011

But how do I use both rows? In an array? query[2][20][25]; quite weird;

---

Re: Little question with MySQL and multiple rows - Calgon - 01.06.2011

If you used the other MySQL plugin I'd be able to help you.

---

Re: Little question with MySQL and multiple rows - steki. - 01.06.2011

How would it be on if I used G-sTyLeZzZ's ?

---

Re: Little question with MySQL and multiple rows - steki. - 01.06.2011

Well, problem shot.

In my AdminRecord System, I had to create two lines, cid (characterid) and cidi (character id index) to make a loop and look throught all the records. Anyways thanks Calg00ne.

---