Does not create table data
#8

I just explained how this works in a recent topic

PHP код:
    new query[200]; 
    
format(querysizeof(query), "INSERT INTO ekwipunek (`slot1nazwa`, `slot1wartosc`,`nick`) VALUES ('%e', '%d','%e')",brak0PlayerName(playerid)); //add %e is string escape 
    
mysql_tquery(SQL_ID,query); 
    new 
query[200]; 
    
format(querysizeof(query), "INSERT INTO bank (`uid`, `stan`, `nick`) VALUES ('%i','%i','%e')"pDane[playerid][UID],pDane[playerid][wBank],PlayerName(playerid));//add %e is string escape 
    
mysql_query(SQL_ID,query); 
Click me!

now it is possible to do CREATE in MYSQL 41-R2 although I had not tested it fully, and no I am not going to test it more since, it's a waste of time. Since creating a table happens only ones and it does not need to be repeated.

but in my opinion

PHP код:
mysql_format(/* Your Query Inside */)
mysql_tquery 
example
PHP код:
mysql_format(querysizeof query"CREATE TABLE IF NOT EXISTS `accounts` (id int(11) NOT NULL)");
myqsl_tquery(databasequery); 
something like this should work, I had made it work before on older versions but not on the latest ones
Reply


Messages In This Thread
Does not create table data - by Eripe - 08.04.2018, 08:13
Re: Does not create table data - by ForCop - 08.04.2018, 08:28
Re: Does not create table data - by Eripe - 08.04.2018, 08:56
Re: Does not create table data - by ForCop - 08.04.2018, 08:59
Re: Does not create table data - by Eripe - 08.04.2018, 09:20
Re: Does not create table data - by ForCop - 08.04.2018, 09:27
Re: Does not create table data - by Eripe - 09.04.2018, 14:12
Re: Does not create table data - by JesterlJoker - 09.04.2018, 15:15

Forum Jump:


Users browsing this thread: 2 Guest(s)