multiple variables to a string
#10

Should be simple enough if you fetch it as string directly from MySQL using GROUP_CONCAT(). This does exactly what you want and you don't need to process it any further in Pawn.

PHP код:
SELECT NameGROUP_CONCAT(Reason SEPARATOR ', ') AS Crimes FROM yourtable WHERE Name 'Avril' GROUP BY Name 
And while we're at it, this one may be useful to list all the current tables in your database:
PHP код:
SELECT TABLE_SCHEMAGROUP_CONCAT(TABLE_NAME SEPARATOR ', ') AS tables FROM information_schema.TABLES WHERE TABLE_SCHEMA 'samp-server' GROUP BY TABLE_SCHEMA 
Reply


Messages In This Thread
multiple variables to a string - by izeatfishz - 27.01.2016, 18:34
Re: multiple variables to a string - by Virtual1ty - 27.01.2016, 19:31
Re: multiple variables to a string - by izeatfishz - 27.01.2016, 19:35
Re: multiple variables to a string - by Virtual1ty - 27.01.2016, 19:44
Re: multiple variables to a string - by izeatfishz - 27.01.2016, 20:07
Re: multiple variables to a string - by AmigaBlizzard - 27.01.2016, 20:54
Re: multiple variables to a string - by izeatfishz - 28.01.2016, 21:29
Re: multiple variables to a string - by izeatfishz - 08.02.2016, 18:37
Re: multiple variables to a string - by Jefff - 08.02.2016, 20:53
Re: multiple variables to a string - by Vince - 08.02.2016, 21:41

Forum Jump:


Users browsing this thread: 1 Guest(s)