[SkinnyBruv]

Howdy Guys,

Just wondering how you get a random row from a database

For Example:
"SELECT random column FROM tableName;
Then do this function with the 3 values that come from that Column

Cheers

If you need any more information just chuck us a reply or add on steam for InRealTime talk
Steam: SkinnyBruv #Scum

[Kailo]

em, this not sourcemod question, is't SQL. And if use google http://stackoverflow.com/questions/1...dom-row-in-sql
For MySQL:

SELECT column FROM table ORDER BY RAND() LIMIT 1

[SkinnyBruv]

You must have mistaken me, im trying to do this with Sourcemod

I know how to do it with MYSql, but how do you choose a random table from MySQL using sourcemod, and then use this table to create like a spawn with it...

[Darkness_]

Originally Posted by SkinnyBruv Just wondering how you get a random row from a database

Originally Posted by SkinnyBruv but how do you choose a random table

Well, which one is it?

[DarkDeviL]

Originally Posted by Kailo em, this not sourcemod question, is't SQL. And if use google http://stackoverflow.com/questions/1...dom-row-in-sql For MySQL: SELECT column FROM table ORDER BY RAND() LIMIT 1

Now you're so smart to suggest Google, have you considered using Google yourself, to find out if "ORDER BY RAND()" could be a bad idea?

If you have a large database, such as player tracking (or store) databases, don't use "ORDER BY RAND()".