mysql_num_rows

[tommekemc]

is there any dbal for mysql_num_rows?
I found sql_num_queries(), but this is something else...
or can I just use mysql_num_rows?

[david63]

The only one I can see is sql_affectedrows() which may give you what you want.

can I just use mysql_num_rows?

Only if you do not plan releasing it as part of a mod.

[tommekemc]

well, that's the problem.
what if I need to use it in my mod?
(did it in another way now...)
I think sql_affectedrows() returns the rows that have changed, isn't it?

[janmyszkier]

no it returns the number of rows that are inside the result of an sql query

[tommekemc]

Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query associated with link_identifier .
and if I check the code it says:

Code: Select all

return ($this->db_connect_id) ? @mysql_affected_rows($this->db_connect_id) : false;

ir means: return mysql_affected_rows (described on top) or return false...
this does not return the amount of rows you've stored in your var...

[janmyszkier]

works fine on SELECT though... just applied it to my mod.

[tommekemc]

well, ok
thanx!

[Paul]

works fine on SELECT though... just applied it to my mod.

Only you should not use i on a SELECT, your MOD will be denied for that .

You actually dont need num_rows, there are always replacements that can be used instead, sizeof at the full resultset, or a do while to check if there is any result, or a COUNT query.

[janmyszkier]

so why do PHPBB code has SELECT and affectedrows in it while it is forbidden? I bet i saw it somewhere, becuase i copied the idea from phpbb to my mod

[Paul]

phpBB3 never uses affected rows on a select. Its not meant for select, its meant for update/delete/insert only.

[janmyszkier]

so i guess the only way is a 'while' ?

[Paul]

it depends on what you want to use it for, there are several replacements for in certian situations.

[tommekemc]

me again, I'm wondering how I can check if there's anything fetched or nothing, how do I do that?
for example:

Code: Select all

if(mysql_num_rowq($sql)==1){
//do code
}else{
//do something else
}

[A_Jelly_Doughnut]

If nothing was fetched, $db->sql_fetchrow will return an empty array. So

Code: Select all

if (!($row = $db->sql_fetchrow($result)))
{
   // The query had no results
}

[tommekemc]

thanx for your reply!
wasn't 100% sure, so I thought I'dd ask it to the pro's :p