Threaded Mode | Linear Mode

Eledrianek · 09-11-2014 09:00 PM

This is the screen of my table kelevar_quests_stats. MySQL access and reading column just one by one (im able to access to the data from "ID_questu" "prijato" etc but not all in one QUERY.

Is there a way how sphere could read whole this table and use its informations in the script?

Or I must use scp like this, with multiple QUERIES:

Code:

//DB.QUERY "SELECT prijato FROM kelevar_quests_stats WHERE ID='<dlocal._for>'"

        //local.prijato=<db.row.0>

        //DB.QUERY "SELECT splneno FROM kelevar_quests_stats WHERE ID='<dlocal._for>'"

        //local.splneno=<db.row.0>

        //DB.QUERY "SELECT preruseno FROM kelevar_quests_stats WHERE ID='<dlocal._for>'"

        //local.preruseno=<db.row.0>

        //DB.QUERY "SELECT ID_questu FROM kelevar_quests_stats WHERE ID='<dlocal._for>'"

Threaded Mode \| Linear Mode mySQL problem - db.row
Author	Message