Display SQL query results in php

Question

I m tring to diplay results in php from sql database  MySQL statement is correct and does what i want in phpMyAdmin but for some reason my code breaks in the webpage   here is the code   require once  db php       sql  SELECT   FROM  modul1open WHERE idM1O gt   SELECT FLOOR  MAX  idM1O     RAND       FROM  modul1open   ORDER BY idM1O LIMIT 1    result   mysql query  sql   echo   result      and here is what i get   In general I need random number limited from min to max by the table id

User · Answer

You need to do a while loop to get the result from the SQL query, like this:

require_once('db.php');  
$sql="SELECT * FROM  modul1open WHERE idM1O>=(SELECT FLOOR( MAX( idM1O ) * RAND( ) )    
FROM modul1open) ORDER BY idM1O LIMIT 1";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

    // If you want to display all results from the query at once:
    print_r($row);

    // If you want to display the results one by one
    echo $row['column1'];
    echo $row['column2']; // etc..

}

Also I would strongly recommend not using mysql_* since it's deprecated. Instead use the mysqli or PDO extension. You can read more about that here.

User · Answer

You need to fetch the data from each row of the resultset obtained from the query  You can use mysql fetch array   for this      Process all rows while  row   mysql fetch array  result         echo  row  column name       Print a single column data     echo print r  row            Print the entire row data     Change your code to this    require once  db php       sql  SELECT   FROM  modul1open WHERE idM1O gt   SELECT FLOOR  MAX  idM1O     RAND       FROM  modul1open   ORDER BY idM1O LIMIT 1    result   mysql query  sql   while  row   mysql fetch array  result         echo  row  fieldname

User · Answer

You cannot directly see the query result using mysql query its only fires the query in mysql nothing else   For getting the result you have to add a lil things in your script like  require once  db php        sql  SELECT   FROM  modul1open WHERE idM1O gt   SELECT FLOOR  MAX  idM1O     RAND       FROM  modul1open  ORDER BY idM1O LIMIT 1      result   mysql query  sql      echo   result   while   row   mysql fetch array  result  MYSQL ASSOC         print r  row       This will give you result

[php] Display SQL query results in php

Examples related to php

Examples related to mysql

Examples related to random

Examples related to numbers

Examples related to generator