mysql两个数组组合,在一个数组中合并两个MySQL查询

Purpose of this query is to retrieve a true image plus 3 random generated images from same table, then show them randomly. User(child) have to select correct image.

Thanks

$sql= "SELECT * FROM `login` WHERE `user` = '$word'";

" UNION"

"SELECT * FROM `login` WHERE `user` != '$word' ORDER BY RAND() LIMIT 3";

$row2=mysql_query($sql);

$i=1;

while ($r = mysql_fetch_array($row2))

{

echo '

';

echo '
';

echo $r['user'];

echo '

';

$i++;

}

解决方案$sql = "(SELECT * FROM `login` WHERE `user` = '$word')";

$sql.= " UNION";

$sql.= " (SELECT * FROM `login` WHERE `user` != '$word' ORDER BY RAND() LIMIT 3)";

$sql.= " ORDER BY RAND()";

To get the results you can use for example (poseted before OP added his code with mysql_* functions):

$MySQL=new mysqli("localhost", "username", "password", "database");

$query = $MySQL -> query($sql);

while ($entry = $query -> fetch_row())

{

// $entry is an array with the results, use for example:

echo $entry[0]; // will return the first column of your table

echo $entry[1]; // will return the second column of your table

// try also:

var_dump($entry); // outputs everything for testing purposes

}

Please, don't use the mysql_* functions, they are deprecated and will be removed in the future versions of PHP. Use MySQLi or PDO instead. See Why shouldn't I use mysql_* functions in PHP? for more details.