loading data from 2 tables in 1 query
#1

this loads info from 1 mysql table
Код:
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `info` WHERE `player` = '%e' LIMIT 1", name);
mysql_tquery(mysql, query, "Loading", "i", playerid);
and if I want to load info from other table (table name : "veh") as well should the code look like this?:

Код:
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `info`, `veh` WHERE `player` = '%e' LIMIT 1", name);
mysql_tquery(mysql, query, "Loading", "i", playerid);
Reply


Messages In This Thread
loading data from 2 tables in 1 query - by ax1 - 24.01.2017, 17:56
Re: loading data from 2 tables in 1 query - by Misiur - 24.01.2017, 17:59
Re: loading data from 2 tables in 1 query - by Vince - 24.01.2017, 18:18

Forum Jump:


Users browsing this thread: 1 Guest(s)