$dbi to $db conversion for sql_result() ?

7ekno · New Member Joined: Dec 22, 2005 Posts: 13

Hi ya

Just a quick question, I am trying to convert a few older modules I have laying around the place, and was wondering if there is a better way to do the following:

First, an example of the old code:

Code:

$tmpOpponentID = mysql_query("SELECT blackPlayer FROM games WHERE gameID = ".$_POST['gameID']);
$opponentID = mysql_result($tmpOpponentID, 0);

Then the code that I have converted it to that works:

Code:

$tmpOpponentID = $db->sql_query("SELECT blackPlayer FROM "$.prefix."_chess_games WHERE gameID = ".$_POST['gameID']);
$row = $db->sql_fetchrow($tmpOpponentID);
$opponentID = $row[0];

My question is: Is there some other function that I am missing that does the above, without the temporary assignment of $row?!? Is there an equivalent function of mysql_result(), that actually returns a single element from an array of database queries?!?

Thanks,
7

montego · Posted: Wed Apr 22, 2009 6:48 am

Well, there are a couple of options, such as:

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT blackPlayer FROM "$.prefix."_chess_games WHERE gameID = ".$_POST['gameID']));
$opponentID = $row[0];

You should also be able to do this:

Code:

list($opponentID) = $db->sql_fetchrow($db->sql_query("SELECT blackPlayer FROM "$.prefix."_chess_games WHERE gameID = ".$_POST['gameID']));

7ekno · New Member Joined: Dec 22, 2005 Posts: 13

Thanks Montego,

You rock Smile

I didn't realise I could pass a query to _fetchrow !!!

Thanks again Smile

montego · Posted: Mon Apr 27, 2009 9:42 pm

You can't because I am a goofball!!!!! I have corrected the above examples to include the sql_query... that is what I get for posting in a rush.

7ekno · New Member Joined: Dec 22, 2005 Posts: 13

Hehe

Thanks, did try passing a query to _fetchrow, and when it didn't work, I figured ya meant it like above Razz

I have "standardised" on the list() method for single elements, and just leaving arrays as is via _fetchrow Wink

I have even managed to implement auto table creation in an Administration module for the standalone version of "WebChess v0.8.2" found around the place, all up-to-date and RN2.30.01 compliant!!

7