About mysql

[keisko]

Hello,

What should I change in below code:
I didnt see mysql_num_rows and mysql_fetch_row functions in the mysql.php


function get_topic_forum($topicid)
**{
******global $DB;
****$res = $DB->query("SELECT forumid FROM topics WHERE id=$topicid");

****if (mysql_num_rows($res) != 1)
******return false;

****$arr = mysql_fetch_row($res);

****return $arr[0];
**}

[crashnet47]

What exactly is your question?

mysql_num_rows() counts the number of rows queried.

mysql_fetch_row() gets the rows queried and puts them into an array that you can traverse to access the information, usually by field name, in this case "forumid" because this is the only field being selected in the query.

[keisko]

e.g.
if (mysql_num_rows($res) !=1)

^^ should be

if ($DB->get_num_rows($res) !=1)

understood?

but I dont know how to change below code
$arr = mysql_fetch_row($res);

[crashnet47]

Oh ok. Sorry for the confusion.


function get_topic_forum($topicid)
{
****global $DB;
****$res = $DB->query("SELECT forumid FROM topics WHERE id=$topicid");

****$topicrows = $DB->get_num_rows($res);

****if ($topicrows != 1)
****{
********return false;
****}
****
****$arr = $DB->fetch_array($res);
****return $arr[0];
}


That should do it for you. :) The function you were looking for is fetch_array().

[spib]

Actually what he really ought to write is

function get_topic_forum($topicid)
{
****global $DB;
****$arr = $DB->query("SELECT forumid FROM topics WHERE id=$topicid");

****return $arr[0];
}

[crashnet47]

True, that would return a false anyway if it didn't exist. But he knows about the fetch_array() function now. :)

[spib]

sorry, my code has a mistake in it. I meant to use the query_first function

function get_topic_forum($topicid)
{
****global $DB;
****$arr = $DB->query_first("SELECT forumid FROM topics WHERE id=$topicid");

****return $arr[0];
}