Menu
Community /Pin to ProfileBookmark
@NogDogOct 14.2009 — #You'll probably want to select the table in your PHP code, then plug it into the SQL:
@NogDogOct 14.2009 — #
Yes, I mind. :p
If I'm doing it for free, I prefer to keep it in public forums; otherwise providing personal services for a fee as part of my freelancing work.
Sql random query
mysql_query(“SELECT * FROM RAND(titles, titles1, titles2) ORDER BY RAND() LIMIT 0,1”)
i know what i did above is probably wrong
but what im trying to do is, select a random table out of the 3 above
and select a random row out of the random table
is there anyways of doing this?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogOct 14.2009 — #You'll probably want to select the table in your PHP code, then plug it into the SQL:[code=php]
$tables = array(
'titles',
'titles1',
'titles2'
);
$table = $tables[array_rand($tables)];
$sql = "SELECT * FROM $table ORDER BY RAND() LIMIT 1";
[/code]0
@NogDogOct 14.2009 — #haha your a smart guy you seem to answer most of my questions
do u care if i just message you with some of my questions[/QUOTE]
Yes, I mind. :p
If I'm doing it for free, I prefer to keep it in public forums; otherwise providing personal services for a fee as part of my freelancing work.