db_fetch() - fetches a result set
mixed *db_fetch( int handle, int row );
Fetches the result set for the given row of the last executeted sql on
the passed database handle.
Returns an array of columns of the named row upon success an error
string otherwise.
string *res;
mixed rows;
int dbconn, i;
dbconn = db_connect("db.server", "db_mud");
if(dbconn < 1)
return 0;
rows = db_exec(dbconn, "SELECT player_name, exp FROM t_player");
if(!rows)
write("No rows return3d.");
else
if(stringp(rows)) /* error */
write(rows);
else
for(i = 1; i <= rows; i++)
{
res = db_fetch(dbconn, i);
write(res[0]);
write(res[1]);
}
db_close(dbconn);
db_exec(3), valid_database(4)