mysql result question

[phpbuild12]

Hello, I would like to ask about mysql_result function.

I have to supply 3 parameters inside. First a place where to look (usually a query where you grab data). The second one I dont understand. And the third one is the field from database, am I correct?

[traq]

You should not use any of the mysql_* functions.
They are long outdated and no longer recommended for use - use mysqli or PDO instead.
Read more about choosing an API for MySQL.

The second parameter of mysql_query() is the row number, starting with 0 (the first row).

[bradgrafelman]

First of all, I agree with traq: Stop Using the MySQL Extension!

However:

The second one I dont understand.

Which part of the following description (taken from the PHP manual for mysql_result(), of course):

The row number from the result that's being retrieved. Row numbers start at 0.

don't you understand?

[phpbuild12]

Ohh so it means it will return ALL rows, but start at 0?

[bradgrafelman]

It can return all rows if called repeatedly, sure. But if you're calling it more than once, then you should probably just be using one of the fetch_*() functions inside a while() loop instead.

[traq]

Ohh so it means it will return ALL rows, but start at 0?

No, it returns whatever field you ask for, from whatever row you ask for. If you pass "0" in the second parameter, it will read from the first row.

As bradgrafelman says, you can loop though all the rows by calling the function repeatedly, but there are much better ways to do that.

[bradgrafelman]

you can loop though all the rows by calling the function repeatedly, but there are much better ways to do that.

... for example: mysqli_fetch_all()