samedi 21 janvier 2017

unable to generate multiple random words at a time using order by rand using php mysql

Hi friends am trying to produce random words using order by rand but unable to produce.Here is my code

       for($i=0;$i< 10;$i++){

        $result = mysqli_query($conn,"SELECT * FROM questions ORDER BY RAND() LIMIT 2");
        if (!$result) {
            /*die('Invalid query: ' . mysql_error());*/
             die("Query failed".mysqli_error());
        }

        while ($row = mysqli_fetch_array($result)) {
                $meta_descriptions = '{'  $row['fact'] . '&nbsp;' . $row['fact'] . '}';
                echo $meta_descriptions;               
             }

        }

My questions table has one column that is column fact. i t has three values like

    apple
    ball
    cat

Am getting output as

   ball ball only

I want it to be random like

     ball cat 

How can I generate it




Aucun commentaire:

Enregistrer un commentaire