[leo9]

I wanna make a script with shows the shop owner from sql now i have the first shop

Код:

new shop1name[128];

i wanna to get the shop1name text from table shops from row 1 and column called name Like this:
|------
|Column|Type|Null|Default
|------
|id|owner|name|money|sellprice
|1 |guest|Pizza |32137|23123

How get the "pizza" and put it in shop1name ?

[RenovanZ]

pawn Код:

mysql_query("SELECT `name` FROM `dbname` WHERE `id` = 1");

[leo9]

it automaticaly select the table and how to put it in shop1name?

[Faisal_khan]

Use cache_get_content.

pawn Код:

shop1name = cache_get_content(params);

Search the wiki for the params. Currently from mobile so I cannot show that.

[leo9]

Can someone make example for me pls i cant it dont show in 3dlabeltext

[RenovanZ]

What version MySQL are you using ?

[leo9]

Im using R33
wiki.sa-mp.com/wiki/MySQL/R33

[RenovanZ]

Use cache_get_row.

pawn Код:

cache_get_row(rownumber, fieldnumber, shop1name);

In your case its row number 0 and field 2
* Rows and Fields number begins from 0 *

[leo9]

how select table?

[RenovanZ]

You dont need to select the table, just:

pawn Код:

new shop1name[128];
cache_get_row(rownumber, fieldnumber, shop1name);
new string[50];
format(string, sizeof(string), "Shop ID 1 Name: %s", shop1name);
SendClientMessage(playerid, -1, string);