I need to combine the results of two/three MySQL queries into one well shuffled result. Can anyone help?
The solution would depend on the version of the MySQL server you're using. The easiest would probably be to use a union query, if supported by your version, and sort it by what ever column is appropriate. Alternatively, put the result of he queries into a temporary table and use this table to return the combined result. Depending on the nature of your result set, it may also be viable to get the result of the queries returned to your client directly (php?) and do the merging/shuffling there.